|
|
#5
09-01-2018, 03:26 PM
|
||||
|
||||
The Filename part is in cell A1 (for example) and that cell contain the likes of: Queen St Roster - and that cell is on the active sheet:
MyFileName = CurrentWB.Path & "\" & Range("A1").value & Format(Now(), "dd-mm-yyyy") & ".csv" If that cell is on a sheet called, say, Sheet33, then: MyFileName = CurrentWB.Path & "\" & Sheets("Sheet33").Range("A1").value & Format(Now(), "dd-mm-yyyy") & ".csv" 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Entering a column value in a cell, to be used as part of a reference in a formula in another cell
|
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
| entering name in outlook does not autofill | Franksplace2 | Word | 0 | 03-08-2015 04:10 PM |
|
entering duration in months
|
ketanco | Project | 1 | 12-17-2014 01:09 PM |
|
entering lump sum costs
|
ketanco | Project | 1 | 12-24-2011 12:56 PM |
| Entering Contact details | GemmaD | Outlook | 0 | 12-18-2008 06:41 AM |
Windows 10 
Office 2016
Threaded Mode