Run-time error 9 when VBA is saving

[joshoftexas]

We are running a purchase order excel document saved to the public drive. To generate a unique number between different computers it runs a macro to open a separate "source" document, pull the number, then save. This has worked flawlessly for the past 4 weeks, however I am now getting a run-time error 9 and the debug is pointing me to the save changes line. Even though the code has not changed. Anything I can do?

Please Login or Register  to view this content.

"Workbooks("PO_Number_Source").Close SaveChanges:=True" is where the debug is pointing me

[Norie]

Does this work?

Please Login or Register  to view this content.