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

Top