Use VB.Net to write to Save Excel File

  • Thread starter Thread starter michealmess
  • Start date Start date
M

michealmess

I have an excel application which is using vb.net to import data into
range names from a SQL database. My users could be using any version of
Excel so I am using late binding in vb.net with no reference to Excel.
I have tested a vb.net app which selects a excel file and imports data
to and it saves. But how can I do this from within Excel using vb.net

I have
Friend mobjExcel As Object = CreateObject("Excel.Application")

and the following lines does nothing.

mobjExcel.ActiveWorkbook.Save()
 
Back
Top