View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Can i set a reference programmatically?

Use late binding and you won't have to worry about it.

--
Regards,
Tom Ogilvy


"Dave F" wrote in message
...
Hi

Excel '97 & 2000, AutoCAD 2002

I've written a VBA routine in AutoCAD that pulls in info from an Excel
worksheet.
The 2 machines I use have different versions of Excel that use different
versions of their object library.
How do I reference the library that's required from within VBA.

Thank in advance

Dave F.