|
|
#4
09-01-2018, 12:34 AM
|
|||
|
|||
A little question. How do I reflect a cell value as part of the file name when I am saving it?
MyFileName = CurrentWB.Path & "\" & "Queen St Roster - " & Format(Now(), "dd-mm-yyyy") & ".csv" Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=MyFileName, FileFormat:=xlCSV, CreateBackup:=False, Local:=True ActiveWorkbook.Close SaveChanges:=False Application.DisplayAlerts = True MsgBox "CSV file has been created " 
|
|
|
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