Variable References via vba based on Access version

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is it possible to use code to modify references for an application? Can I,
for example, set up some code that will run when an app is launched and, if
the user's machine has office 10 then a reference to Microsoft Office Word 10
Object Library will be selected even though the development machine had
Office 11?

Boiled down to it's essence, can I add/change/remove references via code
based on some testable criteria like the existence of a particular file on
the computer on which the application is running?

Thanks,
CW
 
Is it possible to use code to modify references for an application?
Can I, for example, set up some code that will run when an app is
launched and, if the user's machine has office 10 then a reference to
Microsoft Office Word 10 Object Library will be selected even though
the development machine had Office 11?

It's safer to use late binding and use a default object identifier like
"Winword.Application" without any version number.

Hope that helps


Tim F
 
thanks a lot for the replies.

I'll look into it. I don't have a great deal of experience automating word
as it is, but maybe I can figure it out.

CW
 
Back
Top