Automating An Excel 2007 Application using VB

G

Guest

I seem to having a problem getting the VB code to recognize the statements
that declare the automation object type and creating an instance of it after
I have added the refernce to it from the object browser. Is there a sample
program available or some code that will illustrate what is wrong with this
code for Excel 2007?

Dim xlApp As Microsoft.Office.Interop.Excel.Application

xlApp = CType(CreateObject("Excel.Application"),
Microsoft.Office.Interop.Excel.Application)
 

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

Excel 2007 Programming Error - 0x80010105 2
How to pass parameters to excel from wscript (Windows script) 5
VSTO Excel 2003 to VB 6.0 Type Mismatch 1
Object Library feature not supported 8
ASP.Net won't allow Creation of Excel 4
How to Call (utilize) a Sub() in a Class DLL? 9
Excel COM application hangs on Workbooks.Open 1
EXCEL.EXE process does not end after adding an excel chart 4

Top