Excel OpenCurrentDatabase fails error 7866

C

Corrado

Hi, I have problems with an Excel file that uses OpenCurrentDatabase in a VBA
macro... It fails with Visual Basic error 7866

On some pc the same file works fine, on other I have the problem.
When I've tested it I'm sure there was no other users opening the same
database or excel file.
In the past I solved the same problem changing the macro protection to level
"low" (excel and Access) but this time it doesn't work.
We are using Office version 2003 SP2

Thanks
Corrado
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Embed the same Excel multiple times 0
OPENCURRENTDATABASE - Error 7866 / Office 2003 and security. 1
Word macro that can call cells out of Excel for a find and replace 0
OpenCurrentDatabase in Second Instance of Access Does Not Throw Error If It Failes 6
Difficulty opening Access from within Excel 2
"Compile error in table level validation expression " after format 0
How do I set focus (and select text) on a text box on a modeless userform? 0

Top