Anyone ever automated the saveas process utilizing a cell value for PART of the filename?
I need to put a button on the sheet that saves the file with the cuurent filename + contents of a cell (k2).. for example if the current filename is "file1" and the contents of Cell K2 is "test" I need a macro to save the workbook as "file1_test.xls"
Here is what I have but don't know how to integrate the contents of a cell..
ChDir "I INSERT PATH HERE"
ActiveWorkbook.saveas Filename:= _
"I INSERT FULL PATH & FILENAME HERE", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
I need to put a button on the sheet that saves the file with the cuurent filename + contents of a cell (k2).. for example if the current filename is "file1" and the contents of Cell K2 is "test" I need a macro to save the workbook as "file1_test.xls"
Here is what I have but don't know how to integrate the contents of a cell..
ChDir "I INSERT PATH HERE"
ActiveWorkbook.saveas Filename:= _
"I INSERT FULL PATH & FILENAME HERE", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False