VBA Code to add "Microsoft Excel 12.0 Object Library" to Access .mdb VBA module

[EagleOne]

What is the VBA Code to add "Microsoft Excel 12.0 Object Library" to an Access .mdb VBA module?

TIA EagleOne

 

[Beetle]

Open a code window, go to Tools/References. Scroll own the list
(it's alphabetical) until you find the "Microsoft Excel 12.0 Object Library"
reference, check it , then click OK.

 

[Douglas J. Steele]

Take a look at the AddFromFile or AddFromGUID methods of the References
collection.

In general, though, using Late Binding means you don't have to worry about
setting a reference. Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SetReferenceToDAO.mdb" which programmatically sets a
reference to DAO (Microsoft DAO 3.6 Object Library) if it does not exist.
Setting a reference to Excel would be similar and you should be able to
generalize from it.

You can find the sample here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=270

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[EagleOne]

Thanks Doug

 

[EagleOne]

Thanks Roger

 

[Tony Toews [MVP]]

What is the VBA Code to add "Microsoft Excel 12.0 Object Library" to an Access .mdb VBA module?

Now why do you want to add a reference on the fly? Or will late
binding take care of the issues?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/