E
EagleOne
What is the VBA Code to add "Microsoft Excel 12.0 Object Library" to an Access .mdb VBA module?
TIA EagleOne
TIA EagleOne
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
VBA Code to add "Microsoft Excel 12.0 Object Library" to Access .mdb VBA module
B
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.
(it's alphabetical) until you find the "Microsoft Excel 12.0 Object Library"
reference, check it , then click OK.
D
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
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
R
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
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
E
EagleOne
Thanks Doug
E
EagleOne
Thanks Roger
T
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/