Thread: excel - create a macro to use cell text as part of a file name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
bpeltzer
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote