mattyblueice
Board Regular
- Joined
- Jul 24, 2014
- Messages
- 85
- Office Version
- 365
- Platform
- MacOS
I have been trying to modify my macro to have it reference a cell (contains a formula) as the file name, but I just can't get it to work. The portion of the macro is:
ActiveWorkbook.SaveAs FileName: _
"C:\Users\Matt\Documents\Project Data\&"A20" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
The cell in A20 is this formula: CONCATENATE("Project Status ",TEXT(NOW(),"mm/dd/yyyy hh:mm am/pm")
The materials I have seem to indicate that this should work, but is it because the cell being referenced is a formula and not text? If so, anyway around that?
Thanks for your help!!!
Matt
ActiveWorkbook.SaveAs FileName: _
"C:\Users\Matt\Documents\Project Data\&"A20" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
The cell in A20 is this formula: CONCATENATE("Project Status ",TEXT(NOW(),"mm/dd/yyyy hh:mm am/pm")
The materials I have seem to indicate that this should work, but is it because the cell being referenced is a formula and not text? If so, anyway around that?
Thanks for your help!!!
Matt