The files with names like "A1B2C3D4" are automatically generated by
Excel whenever VBA code is attempting to save the spreadsheet and cannot do
so. But, since you are in code, Excel needs to so something and this is its
answer. Is the original workbook marked as read only through windows? Was
it marked as read only during some previous "save as" operation? Are there
multiple users hitting the workbook at the same time (either as a "shared"
workbook or not)?
I have personally experienced this problem with a multi-user workbook
configuration. My particular issue dealt with VBA code manipulating four
separate workbooks as a "system" and some of my users was opening one of
those workbooks "manually" and keeping it open. Therefore, my code, when
attempting to save data from one of the other users, could not do so and I
ended up with a file like A1B2C3D4. I solved the problem by placing a
password on that particular workbook and modifying my VBA code to open the
workbook with that password.

Steve in Ohio

"viaene" wrote:

Hello,

Hopefully someone can help me with a strange problem I've encountered
with Excel:

I have an excel file with some VBA code. Now everytime I save the
file, there is an extra file created in the same directory/folder with
a filename like 'F43D6910'. If I close the file and reopen it, all my
changes are saved. I'm working on Windows XP but some of my collegues
still have NT. If they try to save the file, Dr Watson appears
(opening the file is no problem...).
If I double clic one of the created files, excel opens and I noticed
that it was a copy of my original xls file.
The main problem is that every additional file has the same size as
the original excel file, and when I tried deleting these files, I
could no longer open the original file.

Has anybody an idea what causes this and how to solve this problem.

Many Thanks