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.