VBA Run Time Error when saving workbook between Users....?

Thanks JosephP. Quick question how do i add code tags.

We are both using Microsoft office 10

The error is:

Run-Time error '1004':

Document not saved. The document may be open, or an error may have been encountered when saving.

No. I checked the folder rights and the user has full rights. The weird part is that other users can save just fine but only 2 cannot and receive the same error

I've ran into a similar problem before. It sounds like the user either doesn't have access to the drive, or since it's a shared drive, the file has already been saved and someone unknowingly has it open, therefore it can't overwrite the existing file that has the same name. Could be something else, but this was the problem for me. I fixed it by adding an IF statement to check if the file was already open

Thanks VBA FTW.

You don't happen to have any suggestions on adding the If statement to the code below do you that you mention above to help avoid the run time error?

Please Login or Register  to view this content.

I'm sorry but I was mistaken, I didn't use an IF statement, I used "On Error GoTo" instead. See edited code below (untested). Keep in mind I do not know if your problem is exactly the same as the one I had, so I don't know if this will fix your issue or not, but it's worth a shot. May want to test it out in a copy workbook to play it safe.

Originally Posted by slu2383

Thanks VBA FTW.

You don't happen to have any suggestions on adding the If statement to the code below do you that you mention above to help avoid the run time error?

Please Login or Register  to view this content.

Originally Posted by VBA FTW

I'm sorry but I was mistaken, I didn't use an IF statement, I used "On Error GoTo" instead. See edited code below (untested). Keep in mind I do not know if your problem is exactly the same as the one I had, so I don't know if this will fix your issue or not, but it's worth a shot. May want to test it out in a copy workbook to play it safe.

Thinking about this a little more, the edited code above won't help you identify if the file is actually open, rather, if an error happens, it will popup the msgbox rather than the VBA debug screen. Sorry for the confusion slu2383. But it still sounds to me like someone has the file open therefore the macro can't overwrite it. You may need to figure out if this is the case internally in your office and if you find that is indeed the problem, we can then get into writing some code to get around this.

Also, if you find that someone DOES indeed already have the file open, you can set OpenAfterPublish to false which, like the name implies, doesn't open the PDF after saving. Unless you want the user to be able to preview the file they're saving.

Thanks VBA FTW.

We tried both scenarios. The run time error came back up when I switched the OpenAfterPublish to false. In the second test the message box did pop up but we checked and nobody has the file open.

One of those weird mysteries I guess.

Hmmm...well there's got to be something causing this issue, I'll definitely be thinking about this one