Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |