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

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 ,
Lins 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


--
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 ,
Lins 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

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" wrote in message
...

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