Generating File Names

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Is there a way I can automatically generate a file name
using the contents of a cell. i would like the user to
be able to simply press Ctrl+s and save the file name as
a unique number generated in a cell.

Thanks
 
Barry,

Try something like

Activeworkbook.SaveAs Filename:= "C:\myTest\" & Range("A1").Value &
".xls"

--

HTH

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