Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel doc keeps making a backup after macro is ran
I have a macro that just updates formatting in an excel document (can link if needed but hoping its a simple fix), but once I click save it creates a backup copy without the format changes in the same directory. Every time I open the excel doc and make a change it creates another backup copy in the same directory. How do I stop this? -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: http://www.thecodecage.com/forumz/member.php?userid=425 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107460 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel doc keeps making a backup after macro is ran
Does it have a file extension of .xlt? If so, the template cannot be
changed, so it will always have the old file plus a file with any changes. "jd316632" wrote in message ... I have a macro that just updates formatting in an excel document (can link if needed but hoping its a simple fix), but once I click save it creates a backup copy without the format changes in the same directory. Every time I open the excel doc and make a change it creates another backup copy in the same directory. How do I stop this? -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: http://www.thecodecage.com/forumz/member.php?userid=425 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107460 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel doc keeps making a backup after macro is ran
Yes it does have a .xlt extension, thank you for the information, I guess I'll just keep deleting them then! JLGWhiz;384390 Wrote: Does it have a file extension of .xlt? If so, the template cannot be changed, so it will always have the old file plus a file with any changes. "jd316632" wrote in message ... I have a macro that just updates formatting in an excel document (can link if needed but hoping its a simple fix), but once I click save it creates a backup copy without the format changes in the same directory. Every time I open the excel doc and make a change it creates another backup copy in the same directory. How do I stop this? -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: 'The Code Cage Forums - View Profile: jd316632' (http://www.thecodecage.com/forumz/member.php?userid=425) View this thread: 'Excel doc keeps making a backup after macro is ran - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=107460) -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: http://www.thecodecage.com/forumz/member.php?userid=425 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107460 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel doc keeps making a backup after macro is ran
Usually, when a template is saved, it is done with the SaveAs method so it
can be given a different name. If you use, SaveAs and give the file a new name, the problem should go away. "jd316632" wrote in message ... Yes it does have a .xlt extension, thank you for the information, I guess I'll just keep deleting them then! JLGWhiz;384390 Wrote: Does it have a file extension of .xlt? If so, the template cannot be changed, so it will always have the old file plus a file with any changes. "jd316632" wrote in message ... I have a macro that just updates formatting in an excel document (can link if needed but hoping its a simple fix), but once I click save it creates a backup copy without the format changes in the same directory. Every time I open the excel doc and make a change it creates another backup copy in the same directory. How do I stop this? -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: 'The Code Cage Forums - View Profile: jd316632' (http://www.thecodecage.com/forumz/member.php?userid=425) View this thread: 'Excel doc keeps making a backup after macro is ran - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=107460) -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: http://www.thecodecage.com/forumz/member.php?userid=425 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107460 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel doc keeps making a backup after macro is ran
Here is a site with some information on using templates.
http://office.microsoft.com/en-us/ex...548151033.aspx "jd316632" wrote in message ... Yes it does have a .xlt extension, thank you for the information, I guess I'll just keep deleting them then! JLGWhiz;384390 Wrote: Does it have a file extension of .xlt? If so, the template cannot be changed, so it will always have the old file plus a file with any changes. "jd316632" wrote in message ... I have a macro that just updates formatting in an excel document (can link if needed but hoping its a simple fix), but once I click save it creates a backup copy without the format changes in the same directory. Every time I open the excel doc and make a change it creates another backup copy in the same directory. How do I stop this? -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: 'The Code Cage Forums - View Profile: jd316632' (http://www.thecodecage.com/forumz/member.php?userid=425) View this thread: 'Excel doc keeps making a backup after macro is ran - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=107460) -- jd316632 ------------------------------------------------------------------------ jd316632's Profile: http://www.thecodecage.com/forumz/member.php?userid=425 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107460 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook backup macro | Excel Programming | |||
How do I STOP excel from making a Backup"filename".XLK file | Excel Programming | |||
How do I shut off making a backup copy of a file when I save in E. | Excel Discussion (Misc queries) | |||
Macro to backup? | Excel Programming | |||
making a backup | Excel Programming |