Thread: Macro to "save as"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default Macro to "save as"
What is in cell A2? Try things like these, depending on what you have and what you want to do....

ThisWorkbook.SaveAs Range("A2").Value & ".xls"
ThisWorkbook.SaveCopyAs Range("A2").Value & ".xls"
ThisWorkbook.SaveAs "C:\Folder Path\" & Range("A2").Value & ".xls", AddToMru:=True
ThisWorkbook.SaveAs "C:\Folder Path\FileBaseName " & Format(Range("A2").Value, "yy-mm-dd") & ".xls"

HTH,
Bernie
MS Excel MVP


"JS" wrote in message
...
Hi,

Am using excel 2003 and am wanting to create a macro, attached to a button,
that will save as a particular cell #, say A2, and then print. Have the
print down pat, but can't figure out the save as part.......
--
Thanks for the help


Reply With QuoteReply With Quote