i would like to creat a macro that will save a file automatically when pressed but without deleting the previous one.
can anyone help
i would like to creat a macro that will save a file automatically when pressed but without deleting the previous one.
can anyone help
What would you like to happen - always get the Save As dialog? To change
the name of the previously saved version of the workbook? Something
different?
In article <[email protected]>,
Lins <[email protected]> wrote:
> i would like to creat a macro that will save a file automatically when
> pressed but without deleting the previous one.
i am running a data logger into excell and would like to run a macro at the end of the day to save the data collected. i would like thid to be done at the end of each day automatically by pressing a macro button and the file will be saved under a new name each time
This file might be a help:
http://www.bygsoftware.com/examples/...doublesave.zip
It's in the "Administration Utilities" section on page:
http://www.bygsoftware.com/examples/examples.htm
This saves a workbook and creates a backup version in the same directory.
Click on the button and the workbook will be saved, and backed up, into the
directory where you downloaded it.
There are two backups created with this version: one as
filename_yyyymmdd_hhmmss.zip and filename_yyyymmdd.zip. The first gives you
an incremental backup everytime you save your work. This is especially
useful when developing workbooks. The second ensures you have a daily backup
based on the final save you make each day.
The code is open and commented.
Also, take a look here for Byg Software's Save and Backup utility:
http://www.bygsoftware.com/saveandbackup.htm
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"Lins" <[email protected]> wrote in message
news:[email protected]...
>
> i would like to creat a macro that will save a file automatically when
> pressed but without deleting the previous one.
> can anyone help
>
>
> --
> Lins
> ------------------------------------------------------------------------
> Lins's Profile:
http://www.excelforum.com/member.php...o&userid=24223
> View this thread: http://www.excelforum.com/showthread...hreadid=378390
>
One way:
Public Sub SaveButton_Click()
Const sPath As String = "<your path here>"
Const sFName As String = "MyFile_"
ThisWorkbook.SaveAs _
Filename:=sPath & Application.PathSeparator & _
sFName & Format(Now, "yyyymmdd_hhmmss.xl\s"), _
FileFormat:=xlNormal, _
ReadOnlyRecommended:=True
End Sub
In article <[email protected]>,
Lins <[email protected]> wrote:
> i am running a data logger into excell and would like to run a macro at
> the end of the day to save the data collected. i would like thid to be
> done at the end of each day automatically by pressing a macro button
> and the file will be saved under a new name each time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks