I want to move an Excel sheet to Visual Basic 2008 form. How can I do it?

0 votes
asked by about Microsoft Visual Basic 2008 Express Edition
edited by

I want to move an Excel sheet to Visual Basic 2008 form. How can I do it?

1 Answer

0 votes
No avatar answered by (193k points)

You can use a simple code to open the file to be editable in visual Basic.

Paste this in a new file then compile and run:

Dim XLApp As Object
Dim WkBk
XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
WkBk = XLApp.Workbooks.Open(Filename:="PATH_TO_XLS_FILE") 

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...