why is personal.xlsbackup created every time I run a macro
 

I have several macros in the Personal.xls workbook, every time I execute one
of these macros a file is created called personal.xlsbackup for the first
time it's run then personal.xlsbackupbackup for the second time and so on.

why is personal.xlsbackup created every time I run a macro
 

Have you looked through the code to find a routine that is saving the file?
Look for something like ThisWorkbook.SaveCopyAs

On Sun, 20 Feb 2005 04:13:02 -0800, "Seasider II" <Seasider
wrote:

I have several macros in the Personal.xls workbook, every time I execute one
of these macros a file is created called personal.xlsbackup for the first
time it's run then personal.xlsbackupbackup for the second time and so on.

why is personal.xlsbackup created every time I run a macro
 

Yes, that was it. Thanks very much



"Myrna Larson" wrote:

Have you looked through the code to find a routine that is saving the file?
Look for something like ThisWorkbook.SaveCopyAs

On Sun, 20 Feb 2005 04:13:02 -0800, "Seasider II" <Seasider
wrote:

I have several macros in the Personal.xls workbook, every time I execute one
of these macros a file is created called personal.xlsbackup for the first
time it's run then personal.xlsbackupbackup for the second time and so on.