Problems exporting from Access to Excel

[Jenaccess]

Access version 2010
Excel version 2010

Hi,

I added a command button to get one of my access reports to export to excel. The process works perfectly on my computer, but when my colleague runs the report on a different computer and tries to use the button, an error comes up that says "can't complete the output operation" (runtime error 2587).

I've tried to find a solution online, but most of those are geared toward having a full version vs. runtime, and that is not an issue here. Both my colleague and I have full versions, and we are both using Access 2010 and Excel 2010. I just tested on another colleague's computer and it works fine. So it seems like an isolated issue, but I'm not sure how to being to resolve it. Any help would be appreciated. Thank you.

 

[Mihail]

1) Check if the worksheet is in a write protected folder.
2) Check the references.

 

[Jenaccess]

Thank you very much for responding. I just have a couple of follow up questions:

1) Check if the worksheet is in a write protected folder.
Does this have something to do with the trust center, or is it something different?


2) Check the references.
Would you be able to point me in the right direction as to what type of reference I'd be looking for? I don't understand why, but PDF exports fine. It's just excel (and probably word but I haven't tried it) that seems to be having an issue.

Thanks again for your help!

 

[David R]

1) No, does your colleague have access to write files to that folder? Access can only do what the user can do.

 

[Jenaccess]

Hmm, not sure. Is that something I'd be able to check for if I was at the computer? Would that be something my colleague would be able to correct, or would I have to have IT get involved? It's a private office computer, and my colleague is the only user, but we're on a system wide network.

Thank you for bearing with me. I have little knowledge in this area but would like to learn more.

 

[David R]

Yes, your colleague should go to that folder by hand (Windows Explorer) and attempt to paste a dummy file into there. They need to do this under THEIR login, not yours, and on THEIR computer... I hit this recently myself, where my rights let me push a file, but the line staff's rights do not.

 

[Mihail]

2) Check the references.
Would you be able to point me in the right direction as to what type of reference I'd be looking for? I don't understand why, but PDF exports fine. It's just excel (and probably word but I haven't tried it) that seems to be having an issue.

Open the VBA editor , Tools -> References and take a look.
If you see something like "*Missed" then here is the problem. You use a library that is not installed in your colleague's computer

 

[Jenaccess]

I just wanted to come back and say thank you to Mihail and David for your advice. You gave me some good tools to work with that I will apply to solve the problem. Thank you for taking the time to help me.

 

[Mihail]

I am (and, for sure, David is) glad to help you.
Can you share with us the solution ? Where was the trouble ?
This can help me (maybe us) to quickly solve something similar if I (we) will have troubles.