VBA Refrences Hanging up Other users

[Guest]

I have a database that I pull powerpoint files up with. I have tried 3
different ways to do this, all have been successful, on my machine only.
Untill I checked refrences on other users computers, and found that some were
missing, when disabling them, the application works fine. The problem is,
other users may have different missing refrences. Is there a way for me to
check for refrences through vba and if they are not present to enable them. I
don't want to have to go to each computer and check their refrences, but I
also don't want to have to turn all mine off.

 

[Douglas J. Steele]

Is the problem the PowerPoint reference (and do they have a different
version of PowerPoint installed than you)?

Look into using Late Binding, so that you don't need to set a reference to
PowerPoint at all. Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm

OTOH, if it's some other reference, see what MichKa has at
http://www.trigeminal.com/usenet/usenet026.asp