Thread: Bad declartion of Excel in VB program
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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


Reply With QuoteReply With Quote