| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read/write excel and word 2007 documents from another application | Excel Discussion (Misc queries) | |||
| Exporting to Excel 2007 format from asp.net application | Excel Discussion (Misc queries) | |||
| How to open application using Excel 2003 instead of Excel 2007? | Excel Discussion (Misc queries) | |||
| Opening Excel 2007 application | Excel Discussion (Misc queries) | |||
| macro to close excel application other than application.quit | Excel Programming | |||
Linear Mode
