Bad declartion of Excel in VB program

[Mike]

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

 

[Tom Ogilvy]

To use that construct, you need to create a reference to the Excel Object
library - otherwise, VB doesn't know what Excel.Application is.

 

[Mike]

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