Excel macro & MS XP OS trouble

[Gary]

I have recently switched from the MS NT operating system
to the MS XP Professional os. My problem is I have an
Excel macro that used to work with the NT system and now
it does not with XP.
Everytime I try to submit my Excel form I now get the
following error message: "A document with the name '<name
of file>' is already open. You cannot open two documents
with the same name, even if the documents are in
different folders. To open the second document either
close the document that currently open, or renmae one of
the documents."
I have tried to rename the excel file and excel says it
cannot find the file.
Please help me if you can.
Thanks,
Gary

 

[Jim Rech]

I'd try resetting your Excel file associations...

From Start->Run enter "Excel.exe /regserver" (no quotes, space before the
slash) and press Enter.

Your problem is usually associated with opening files via a double-click
through the UI. I'm not sure how a macro would be generating it, but no
harm in trying this.

--
Jim Rech
Excel MVP
|I have recently switched from the MS NT operating system
| to the MS XP Professional os. My problem is I have an
| Excel macro that used to work with the NT system and now
| it does not with XP.
| Everytime I try to submit my Excel form I now get the
| following error message: "A document with the name '<name
| of file>' is already open. You cannot open two documents
| with the same name, even if the documents are in
| different folders. To open the second document either
| close the document that currently open, or renmae one of
| the documents."
| I have tried to rename the excel file and excel says it
| cannot find the file.
| Please help me if you can.
| Thanks,
| Gary
|

 

[Gary]

Jim.

Thanks for the info. I tried this but I am still
receiving the error.
When I open the macro, Excel opens a worksheet. On the
macro I have a submit button that sends the sheet to a
server. This is when I have the problem, at submission.

Frustrating
Thanks Again!!!