Set references by code 1

[ruthcali]

Hello,

In Access97, how can i set references using code? I created a folder on the network drive called G:/MyReferences and copied MSOUTL85.OLB and EXCEL8.OLB into it.

Instead of going to each users's computer and clicking Tools, References, Browse and navigating to the G:/MyReferences folder, can i do that using code?

Thanks!

 

[danvlas]

Application.References.AddFromFile "PathAndFile"

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[ruthcali]

Daniel,
Wow. thanks!! that works.

Should i put 'on error resume next' before
Application.References.AddFromFile "path and filename"?

If not, i get a runtime error: 'name conflicts with exisitng module, project or object library'

Thanks!

 

[ruthcali]

Sorry, to clarify:

I get the runtime error if i run the code more than once. i plan on putting the code in the autoexec.bat macro so it runs everytime the user opens the database.

 

[danvlas]

The error occurs because you try to add a reference that has already been added
You can Resume Next all right.
But you could also the collection:

For Each ref In Application.References
Debug.Print ref.Name & ": " & ref.FullPath
'Do your stuff with the name or path
Next

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[ruthcali]

Thanks Daniel!

My parents are from Romania! What a small world. They grew up around Bucharest.

I can understand Romanian and i can speak a little.


(i found your bio on the RentACoder webpage).

 

[danvlas]

Small world indeed...
And the Internet is making it even smaller - I met somebody on a forum and it turned out we were neighbours

Glad it worked



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html