G Guest Jun 27, 2006 #1 I am trying to write a macro to save a excel spreadsheet and use a cell that contains text like a customer name.
I am trying to write a macro to save a excel spreadsheet and use a cell that contains text like a customer name.
G Guest Jun 27, 2006 #2 Record your macro to include the File > SaveAs, then edit that line of code. Instead of ... Filename:="\\FinancialReporting\FY2006" ..., you might use .... Filename:="\\FinancialReporting\FY" & range("B2").value ...
Record your macro to include the File > SaveAs, then edit that line of code. Instead of ... Filename:="\\FinancialReporting\FY2006" ..., you might use .... Filename:="\\FinancialReporting\FY" & range("B2").value ...
