Hello, How do I create a backup copy of original file every time I run macro in excel? Thanks Configuration: Windows 2000 / Firefox 3.6.13

Create a backup copy

Solved/Closed

may - Feb 17, 2011 at 02:10 PM
may - Feb 17, 2011 at 04:31 PM

Hello,

How do I create a backup copy of original file every time I run macro in excel?

Thanks

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2011 at 02:18 PM

in the macro, you can copy the file or do a file save as before rest of macro is executed.

Answer 2 / 2

may
Feb 17, 2011 at 04:31 PM

Thanks