Thread: Automating An Excel 2007 Application using VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Wylie Brad Wylie is offline
external usenet poster
  
Posts: 9
Default 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
Reply With QuoteReply With Quote