Saving Excel documents from macros

[Rui Alvares]

Hi everyone

To run a macro everytime I open an Excel document, I made a macro in a file
named Personal.xls in ...\Program Files\Microsoft Office\Office10\XLStart.
The macro runs well, but when I save the document it makes two files, one
with the correct name (that I want) and another with a strange name like
AE5B8100 or A06B8100 without extention. This files are also open by Excel
when I make double-click on it.
This files are only occupying space in disk and they aren't temporary files.
Who knows why this happen?
How can I resolve this problem?

Thanks in adavnce.

Best regards

Rui Alvares

 

[Dave Peterson]

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension) in the same folder.

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

If you're seeing that funny named file, then something is going wrong.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.