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

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

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

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



"bossman tv" wrote:

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