I have deployed a program in Excel 2003 that is used to gather and log user input. It has one hangup. After a workbook is submitted it is saved to a network folder under a new system-assigned name. Usually this works fine. However, certain users (using the same version and SP of Excel and the same OS) sporadically receive the following error when the code reaches ActiveWorkbook.SaveAs (NetworkPath):

Run-time error '1004':

Microsoft Office Excel cannot access the file '\\(mynetwork path here)\'. There are several possible reasons:
  • The file name or path does not extist.
  • The file is being used by another program.
  • The workbook you are trying to save has the same as a

None of these conditions are true. I tried using DoEvents to give the system extra time to create the file but that didn't help. And I can't think of a workaround to use with error trapping.

Microsoft did publish an article about this error occuring in this instance (http://support.microsoft.com/kb/291204) but I'm weary to take those steps because I can't be sure it will solve the problem and it involves some registry editing.

Has anyone else run into this? I can't believe it's uncommon but the lack of info on it leads me to believe either it is or there's an easy fix eluding me.

Thanks in advance.