Thread: saving file name based on value in predetermined cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JB
 
Posts: n/a
Default saving file name based on value in predetermined cell
ActiveWorkbook.SaveAs Filename:=Format([b11], "yyyy_mm_dd")

Cordialy JB

Reply With QuoteReply With Quote