View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Reference lost when newer version opens file

Possibly use late binding and not create a reference

Update the reference with code

--
Regards,
Tom Ogilvy


"Rob" wrote in message
...
I have a workbook that uses the Outlook 9 ilbrary. If someone opens the

book
using office 10 then the reference gets updated to Outlook 10, which is

fine
until I open it again in Office 9 and have to mannually tell it to look at
the version 9 library. Is there an easy way to fix this?

Thanks

Rob