Excel macro run in Access errors

K

Kristof

Hello,

I made a macro in Excel that refreshes imported data from
an Access table.
Then I coded a macro in Access that executed the excel
macro. But often run up to 2 kinds of errors:

1) he says the path of the access db is incorrect,
although I'm sure it's the right one. (excel suggests a
new db which is the same as the one I coded);

2) An error saying that the table is locked by an "admin".

Does anybody has a suggestion how to solve these problems.

Thanks in advance,
Regards,

Kristof
 

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

Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Setting column width in a table with a macro is not working 0
Active Content in this file is blocked issue 1
Autonumber field in Excel that behaves the same as Access 0
Can't Run Macro 3
Word VBA - Want to test if Full Name is NOT Present in document 0
List all tables, including document structure 0

Top