View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz quartz is offline
external usenet poster
 
Posts: 35
Default Is it possible to set a reference to a library in another file using VBA in Excel?

Hello, I am using VBA in Excel XP with Windows 2000

Is it possible to set a reference to a library in another file using VBA in Excel

For example, the main program resides in "File A" and it must programmatically set a reference to "Microsoft Outlook 10.0 Object Library" in "File B" for "File B's" use

If this is possible, can someone supply me with the code with which to do it

Thanks much in advance.