View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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