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("E xcel.Applicatio n")
and the following lines does nothing.
mobjExcel.Activ eWorkbook.Save( )
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("E xcel.Applicatio n")
and the following lines does nothing.
mobjExcel.Activ eWorkbook.Save( )