Here's the situation:
I custom designed a process to streamline information from Word to Excel via macro. The process was designed using Office 2010 and Office 2003. At the time I was unaware she had Office 2002.
I went out and set it up, there were a few small errors with code compatibility of course, but there were some manual work arounds that we can do just fine.
The way this macro works is the user fills out a form (form-fields) in Word, the user runs the macro (it was designed to detect if the workbook was open and handle it appropriately, but this feature was apparently not supported in 2002), opens the workbook, and adds data to anywhere from 3-7 different worksheets depending on the user input. If the file does not exist they are attempting to write to does not exist, it was designed to create a new one from a template and save it as the specified name in the current path (but this also died with 2002).
The user has reported that the first time the macro is run, it works great and encounters no problem. However, after that it seems to be nearly all the time (if not all the time), if they run the macro again to add data to the same Excel file she cannot save the file. She receives a "Document not saved" error, or something along those lines. The project folder resides in a shared folder which is accessed by a total of two computers over a wireless network. I have not been able to make it out to her location just yet since initial setup, so I am basing this purely off of what she has told me. I will list below some of the troubleshooting we have done.
The user cannot do the following:
Save the file as a different name in the same folder
Save the file on a local, non shared directory with the same name
Could not save after copying the project directory from the shared folder, and opening the local copy
The file is not open on multiple computers simultaneously. We tried installing Office XP SP3 with no luck. The user is running AVG 9.0.7xx Free Edition. The shared folder resides on her desktop, and the file name is in the format "Mailing Report mm-dd-yyyy" where mm-dd-yyyy represents an actual date. The user is using Windows XP.