Hi.
It looks like a typo in your VBA code. Try using VBE6.DLL instead. If that
still doesn't work, then use Windows Explorer to navigate to where the file
was installed and ensure that the path in the code matches the actual path on
your computer.
If that doesn't work, then you may need to ensure that the library is
properly registered. To do so, click the Windows Start button, and then
click Run. If your VBA library is installed in the default directory
(otherwise, just replace the path with your own), then use the following
command for the VBA library (this is all one line):
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL"
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.