"Document not saved" error. Read on for details...

[ajava]

Here is the scenario:

Macro written/recorded in a blank workbook.
Macro is written to open two other files - an excel file and a .txt file
All files are on a shared drive (here at work)

When I go to save the blank workbook (the one in which the macro "lives"), I get a message - "document not saved".

I write/record macros all the time and I've never gotten this message before. I tried saving all files involved to my hard drive...still got the error message. Can anyone come up with a reason/solution? I've been searching the net all morning...none of the scenarios that I've come across match mine exactly. Thanks.

[ajava]

Just gonna give this a bump, in case any new lurkers have a solution. Thanks.

[Colin Legg]

There's a MS Help&Support article for this error message. The cause doesn't marry up 100% with your description but try the fix in the workaround section anyway - it's definitely worth a shot:

http://support.microsoft.com/kb/291204


Let us know how you get on.