| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| personal.xls created in Excel 2007 and opened in Excel 2002 | Excel Discussion (Misc queries) | |||
| Macro run each time a new workbook created | Excel Discussion (Misc queries) | |||
| Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
| New Named Range Created Each Time Data Imported into Excel via Macro | Excel Programming | |||
Linear Mode
