Open an Excel file using VB 1

[mike777]

I've tried shell("path\filename.xls&quot and, obviously that doesn't work.
So, I've tried
Workbooks.Open "filename.xls" and get the "object needed" error.
I've tried
Getobject ("path\filename.xls&quot, etcetc.
I just need to open an excel spreadsheet from the vb application. Thanks for your help. [sig][/sig]

 

[Guest_imported]

Hey Mike

I am looking for the exact same thing if you find something please let me know.

Thanks
John

 

[nicholasuk]

Hi Mike

This is the way, hope it helps. I have done loads of this type so if you need more help let me know.
I have put a msgbox in so it wont shut it down immediately following. If you did not say myexcel = visible it is still opened but not visible to your screen, ideally for bacground processing.

Kind regards

Andy Nicholas

Function Excel_Example()
Dim myExcel As Object

Set myExcel = CreateObject("Excel.Application&quot

myExcel.Visible = True

myExcel.workbooks.Open Filename:="D:\My Documents\forumExample.xls"

MsgBox ("I am Here&quot

myExcel.workbooks("forumExample.xls&quot.Close

myExcel.Quit

End Function
[sig][/sig]