Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Variables in filenames
I want to automatically name a file created from a particular template.
I want the filename to be todays date. i.e. I open timesheet.xlt and the file is created as My Documents\Timesheets\ddmmyyyy.XLS This template will be distributed to several users. I am using Excel 2002 SP3 |
#2
|
|||
|
|||
ActiveWorkbook.SaveAs Filename:= "C:\MyDocuments\Timesheets\" &
Format(Date,"ddmmyyyy") & ".xls" although I would suggest you use a format of yyyymmdd, so that it is ordered. -- HTH RP (remove nothere from the email address if mailing direct) "Blinky Bill" <Blinky wrote in message ... I want to automatically name a file created from a particular template. I want the filename to be todays date. i.e. I open timesheet.xlt and the file is created as My Documents\Timesheets\ddmmyyyy.XLS This template will be distributed to several users. I am using Excel 2002 SP3 |
#3
|
|||
|
|||
Thankyou for your help
"Bob Phillips" wrote: ActiveWorkbook.SaveAs Filename:= "C:\MyDocuments\Timesheets\" & Format(Date,"ddmmyyyy") & ".xls" although I would suggest you use a format of yyyymmdd, so that it is ordered. -- HTH RP (remove nothere from the email address if mailing direct) "Blinky Bill" <Blinky wrote in message ... I want to automatically name a file created from a particular template. I want the filename to be todays date. i.e. I open timesheet.xlt and the file is created as My Documents\Timesheets\ddmmyyyy.XLS This template will be distributed to several users. I am using Excel 2002 SP3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINEST maximum number of predictor variables | Excel Worksheet Functions | |||
Calculating Percentages with Variables | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Two variables | Excel Discussion (Misc queries) | |||
Index Match With 3 Variables | Excel Worksheet Functions |