Blinky Bill

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LINEST maximum number of predictor variables	Peter N	Excel Worksheet Functions	7	February 17th 05 10:14 AM
Calculating Percentages with Variables	tssjhs	Excel Worksheet Functions	1	January 28th 05 01:27 AM
Add up a Dynamic Range with 2 Variables	John	Excel Worksheet Functions	1	January 15th 05 02:23 PM
Two variables	Blackcat	Excel Discussion (Misc queries)	7	January 7th 05 12:13 PM
Index Match With 3 Variables	Scooterdog	Excel Worksheet Functions	5	January 2nd 05 07:05 PM

All times are GMT +1. The time now is 09:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us