Saving Excel documents from macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rui Alvares - 01 Aug 2007 00:32 GMT

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

Reply to this Message

Dave Peterson - 01 Aug 2007 05:33 GMT

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.

> Hi everyone
>
[quoted text clipped - 13 lines]
>
> Rui Alvares

Signature

Dave Peterson

Reply to this Message