Need Help Finding Right VBA DLL Version

[John Lane]

I installed Office 2007 on Windows Vista Home Premium Edition and now find
certain functions such as Split and UBound don't work (get "undefined
function" in query). I checked and it is referencing a dll named VBE6.DLL.
Then I noiced in the Tools/Reference list there were 4 other Visual Basic for
Applications, referencing 3 OLB's and a DLL. What is the correct VBA library
version and how/where do I get it? Or is one of these on the machine correct?
If so, how do I swap one for the other. I can't the delete the one checked
nor swap it for another. Thanks for any help anyone can give.

 

[Tony Toews [MVP]]

I installed Office 2007 on Windows Vista Home Premium Edition and now find
certain functions such as Split and UBound don't work (get "undefined
function" in query). I checked and it is referencing a dll named VBE6.DLL.
Then I noiced in the Tools/Reference list there were 4 other Visual Basic for
Applications, referencing 3 OLB's and a DLL. What is the correct VBA library
version and how/where do I get it? Or is one of these on the machine correct?

add a reference to "MS VBA Extensibility 5.3"

Then you can use the description property:

Dim ref As VBIDE.Reference

For Each ref In Access.Application.VBE.ActiveVBProject.References
Debug.Print ref.Description
Next

Then we'll let you know which ones to keep and which to discard.

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/