Macro to save file

  • Thread starter Thread starter gfinch
  • Start date Start date
G

gfinch

I would like to create a macro that will name a file and save it so that
the name is the same as the contents of cell A10 + today's date. Is
this possible?
Thanks for all your help.
Gib
 
Gb,

Off the top

ActiveWorkbook.SaveAs Filename:= Activesheet.Range("A10") &
Format(Date,"yyyy-mm-dd")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Gib,

Try something like

ActiveWorkbook.SaveAs Range("A10").Text & _
Format(Now,"yyyymmdd") & ".xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks for both your help. That is exactly what I needed. Inserted
into macro and works like a charm. Thanks - Gib
 
Like my friend here, i'm trying to get a macro to save file name as th
contents of cell I2 (it's a merged cell from I2 to L2) + "filename"

how do I do that. I know it's not too far off from the above solutions
but still, how to I get that
 
Back
Top