excel - create a macro to use cell text as part of a file name

B

bossman tv

I am trying to write a macro to save a excel spreadsheet and use a cell that
contains text like a customer name.
 
B

bpeltzer

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 ...
 
Top