Help with excel

  • Thread starter Thread starter Mike Fellows
  • Start date Start date
M

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
 
Hi Mike,

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

Regards,
Fergus
 
Back
Top