Excel OpenCurrentDatabase fails error 7866

G

Guest

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

OPENCURRENTDATABASE - Error 7866 / Office 2003 and security. 1
error 7866, can't open the database because it is missing, or opened exclusively by another user 2
Difficulty opening Access from within Excel 2
Import 4 Different Excel Files from One Folder 0
Excel On Error Resume Next 2
Code Cleaner menu entry disappeared 10
Problems with opening a VBA contained excel file? 3
excel 2007 recovery loop 0

Top