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.

Can i set a reference programmatically?
 

http://www.erlandsendata.no/english/.../olebasics.php

See this page Dave if you want to know more about Tom his suggestion

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Tom Ogilvy" wrote in message
...
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.