Automatic naming of files

  • Thread starter Thread starter Alan Dresch
  • Start date Start date
A

Alan Dresch

Is it possible to automatically assign the text in a
particular spreadsheet cell to the file name when Saving
or Saving As?
 
Hi Alan,

Yes it is with VBA, for example

Activeworkbook.SaveAs Filename:=Activesheet.range("A1")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
In a standard module enter:

Sub testme()
Application.Dialogs(xlDialogSaveAs).Show _
Worksheets("sheet1").Range("j2").Value & ".xls"
End Sub

Changing, of course the sheet1 and Cell J2...

HTH
 
Back
Top