Automating An Excel 2007 Application using VB
 

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)
--
Brad Wylie

Automating An Excel 2007 Application using VB
 

Have a look here @ Mikes tutorial

http://www.xtremevbtalk.com/showthread.php?t=160433

On Jan 27, 1:16 pm, Brad Wylie wrote:
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)
--
Brad Wylie

Automating An Excel 2007 Application using VB
 

Excellent article and sloves the problem - thanks
--
Brad Wylie


" wrote:

Have a look here @ Mikes tutorial

http://www.xtremevbtalk.com/showthread.php?t=160433

On Jan 27, 1:16 pm, Brad Wylie wrote:
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)
--
Brad Wylie