Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Saving
Hi All,
Sub Saver () ChDir "C:\Documents and Settings\Owner\My Documents\Binder" ThisWorkbook.SaveAs Filename:="AC2.xls" End Sub This is part of a macro I use to edit and save several workbooks that are sent to me daily. What I want it to do is for it offer me the option to specify the file name that I save it as. As it is, it saves as the current filename, albeit that it warns me that I am going to overwrite an existing file. This is of no use to me as part of the filename is the current date. In short, I want to replicate the 'Save As' command where I can specify what I save and where I save it to, Hope I'm making some sort of sense, Any help very much appreciated, Regards, Alan. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Saving
Hi Alan
You can use Application.GetSaveAsFilename Look in the VBA help for more information -- Regards Ron de Bruin http://www.rondebruin.nl "Alan" wrote in message ... Hi All, Sub Saver () ChDir "C:\Documents and Settings\Owner\My Documents\Binder" ThisWorkbook.SaveAs Filename:="AC2.xls" End Sub This is part of a macro I use to edit and save several workbooks that are sent to me daily. What I want it to do is for it offer me the option to specify the file name that I save it as. As it is, it saves as the current filename, albeit that it warns me that I am going to overwrite an existing file. This is of no use to me as part of the filename is the current date. In short, I want to replicate the 'Save As' command where I can specify what I save and where I save it to, Hope I'm making some sort of sense, Any help very much appreciated, Regards, Alan. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Saving
Try something like
Sub Saver () ChDir "C:\Documents and Settings\Owner\My Documents\Binder" ThisWorkbook.SaveAs Filename:="AC2" & Format(Date,"yyyy mm dd") & ".xls" End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alan" wrote in message ... Hi All, Sub Saver () ChDir "C:\Documents and Settings\Owner\My Documents\Binder" ThisWorkbook.SaveAs Filename:="AC2.xls" End Sub This is part of a macro I use to edit and save several workbooks that are sent to me daily. What I want it to do is for it offer me the option to specify the file name that I save it as. As it is, it saves as the current filename, albeit that it warns me that I am going to overwrite an existing file. This is of no use to me as part of the filename is the current date. In short, I want to replicate the 'Save As' command where I can specify what I save and where I save it to, Hope I'm making some sort of sense, Any help very much appreciated, Regards, Alan. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Saving
Thanks to you both,
Alan. "Bob Phillips" wrote in message ... Try something like Sub Saver () ChDir "C:\Documents and Settings\Owner\My Documents\Binder" ThisWorkbook.SaveAs Filename:="AC2" & Format(Date,"yyyy mm dd") & ".xls" End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alan" wrote in message ... Hi All, Sub Saver () ChDir "C:\Documents and Settings\Owner\My Documents\Binder" ThisWorkbook.SaveAs Filename:="AC2.xls" End Sub This is part of a macro I use to edit and save several workbooks that are sent to me daily. What I want it to do is for it offer me the option to specify the file name that I save it as. As it is, it saves as the current filename, albeit that it warns me that I am going to overwrite an existing file. This is of no use to me as part of the filename is the current date. In short, I want to replicate the 'Save As' command where I can specify what I save and where I save it to, Hope I'm making some sort of sense, Any help very much appreciated, Regards, Alan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTOMATIC FILE SAVING | New Users to Excel | |||
AUTOMATIC FILE SAVING in a folder | New Users to Excel | |||
automatic file saving in Excel | Excel Discussion (Misc queries) | |||
Automatic File Saving | Excel Discussion (Misc queries) | |||
Automatic saving | Excel Discussion (Misc queries) |