There is still a problem. I have isolated the error to the line in cod
that attempts to save the open workbook in XL 2000. The line I
"Thisworkbook.Save" that causes the bug. In another place in the cod
I try to save some data in a new workbook which is opened by code an
then saved as "Activeworkbook.save". Same error occurs.

I get a "Error 1007". It says "cannot open file" (?) and says yo
can't have certain characters in the name of the file. I changed th
name of the file to a single word, and the same error comes back "yo
cannot have ":" in the file name. Problem is, there is no ":" in th
file name.

Again, there is no problem with the code in (A) XL 2002, or (B) XL 200
that has been regularly updated. I don't know which update is neede
to fix the problem. Alternatively, I can change the code.

Either way I need some help. The program has been distributed to abou
35 managers who are all waiting for me to fix it...

--
Message posted from http://www.ExcelForum.com