Use VB.Net to write to Save Excel File

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

late binding when vb.net 2005 updates excel 2003 2
Problem with ProcOfLine and ProcBodyLine in VB.Net 0
import data from sql to excel using vb.net 1
Calling an Excel macro from VB.NET 2
Controlling how Excel starts when using VB.Net Automation 3
Using excel solver in VB.NET 7
Option Strict on with Excel Automation using VB.net 2003 0
vb.net forms connected to controls 1

Top