| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bad declartion of Excel in VB program
I'm trying to instantiate a excel application from VB and
have found several examples of programs in MS help articles how to do this. However the statement "xlApp1 As Excel.Application" causes the runtime error "User-defined type not defined" What am I missing? --- Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Bad declartion of Excel in VB program
To use that construct, you need to create a reference to the Excel Object
library - otherwise, VB doesn't know what Excel.Application is. -- Regards, Tom Ogilvy Mike wrote in message ... I'm trying to instantiate a excel application from VB and have found several examples of programs in MS help articles how to do this. However the statement "xlApp1 As Excel.Application" causes the runtime error "User-defined type not defined" What am I missing? --- Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Bad declartion of Excel in VB program
hay Tom. Yep that was it. This now allows me to have an
early binding object. I've been poking at it to try to get the chart to show the graph of the data but unlike the late binding method: xlChart1.SetSourceData Source:=xlSheet1.Range("A1").Resize (100, 2) I can't seem to find the method? Any help would be much appreciated. --- Mike -----Original Message----- To use that construct, you need to create a reference to the Excel Object library - otherwise, VB doesn't know what Excel.Application is. -- Regards, Tom Ogilvy Mike wrote in message ... I'm trying to instantiate a excel application from VB and have found several examples of programs in MS help articles how to do this. However the statement "xlApp1 As Excel.Application" causes the runtime error "User- defined type not defined" What am I missing? --- Mike . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Program | Charts and Charting in Excel | |||
| Excel program | Excel Discussion (Misc queries) | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| Excel program | Excel Discussion (Misc queries) | |||
| merging excel program with tdc finance program | Excel Programming | |||
Linear Mode
