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

Have a look here @ Mikes tutorial

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

On Jan 27, 1:16 pm, Brad Wylie <hbwy...@yahoo.com.modified> 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

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


"(E-Mail Removed)" wrote:

> Have a look here @ Mikes tutorial
>
> http://www.xtremevbtalk.com/showthread.php?t=160433
>
> On Jan 27, 1:16 pm, Brad Wylie <hbwy...@yahoo.com.modified> 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
>
>