Automating An Excel 2007 Application using VB

B

Brad Wylie

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

Working outlook via vba code with xlsx - error 0
Excel 2007 Programming Error - 0x80010105 2
Problems starting Word from Excel VBA 3
EXCEL.EXE process does not end after adding an excel chart 4
Defining XLApp as 2007 App on a machine with 2003 and 2007 loaded 0
How to Call (utilize) a Sub() in a Class DLL? 9
Excel Won't close in .NET 3.5 using C# 0
Excel COM application hangs on Workbooks.Open 1

Top