save as .bak when opening .xls
Hi,
You could add a save as command to the Open_Workbook event. If you only
want this to happen when you open the workbook you will probably need to run
two consecutive saves - one to do the bak and another to resave the file to
where you opened it from. You should be able to record the steps and then
add them to the following:
Private Sub Workbook_Open()
'your code
End Sub
This code goes into the thisWorkbook object in the VBE. Press Alt+F11,
double-click the thisWorkbook object, for your workbook, in the Project
explorer near the top left of the screen.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"avi" wrote:
Is it possible to let Excel save the .xls file to .bak when opening it?
Preferably with a macro.
(I am using Excel 2003).
Cheers,
Avi
|