Bad declartion of Excel in VB program

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
To use that construct, you need to create a reference to the Excel Object
library - otherwise, VB doesn't know what Excel.Application is.
 
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
 
Back
Top