Programatically Control References

[Savil]

Hi All
Access 97 db with vba references to visio 2002!

Some of our 200+ workstations have visio installed and others do not so I am getting 'cannot find library' type errors. How can you remove missing references or add references programatically depending on the software configuration of the machine? These workstations are in the public sector and I have no control over registries.

Thanks

 

[acent]

This might be a point in the right direction for you:

http://support.microsoft.com/kb/209849/EN-US/

You could also check to see if the visio file is present, if so, execute code, if not, then not. Check on File I/O in help.

Hope this helps you.

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws

 

[JoeAtWork]

What I have done in similar situations is use late binding to the library that is not guaranteed to be on all computers. I.e. I don't include it in references, but use CreateObject to instatiate the top level object (I assume in this case it is "Visio.Application").

It is not as efficient as early binding, but in this day and age the difference is usually not noticeable to the mere human.