| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Programmatically add a Formula in a worksheet? | Excel Worksheet Functions | |||
| help creating new hyperlinks programmatically | Links and Linking in Excel | |||
| OWC load add-ins programmatically in dotnet? | Excel Discussion (Misc queries) | |||
| How to add an image to a worksheet programmatically | Excel Discussion (Misc queries) | |||
| How to create picklists programmatically | Excel Programming | |||
Linear Mode
