file access error in opening excel file linked to ms access table

T

topbrahmin

Hi
I have a table in ms access that is linked to a file in excel. For
reasons that are complicated to explain, my vba code must change a cell
in the excel file (i do that using a ADODB connection), and then launch
the excel file (i use the runapp macro), which refreshes the sheet
(traditional refresh methods dont work). Then I go back to using the
linked table that has the new data.

My problem is that the above process works most of the time, but
sometimes, it gives me a "File access denied" message when launching
the excel file. I cannot understand why since it works many times, but
then seemingly randomly it fails. The files are all on a personal drive
so nobody else is using it at the same time.

Any help would be greatly appreciated
 

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

Top