Help with excel

[Mike Fellows]

within my VB.net app I use Excel a lot, so far I have used

Dim excel_app As Object
excel_app = CreateObject("Excel.Application")
excel_app.Workbooks.Add()

and parsed through the spreadsheet adding the data I need to add. Now I
need to be able to open a excel spreadsheet that already exsists
I thought that the excel object would contain a open instance but it does
not and now im stuck

I need to be able to open an excel file and insert the neccesary data into
the correct cells as i would normally (the spreadsheet has so much
formatting on it, that it would take me too long to code)

Thanks

Mike Fellows

 

[Fergus Cooney]

Hi Mike,

This works for me.
oExcel.Workbooks.Open ("C:\Tmp\Foo.xls")

Regards,
Fergus

 

[Mike Fellows]

Thanks Fergus,

I did eventually suss this out but thanks for the reply

Mike