macro to save worksheet using a cell reference

  • Thread starter Thread starter Stan Hess
  • Start date Start date
S

Stan Hess

I'm working from a template and would like to save the speadsheet using
a cell reference, or even better to a notepad using the a cell
reference.

Thank you!!!

Posted via: http://www.ozgrid.com
Excel Templates Training Add-ins.
Free Excel Forum & Business Software
 
how about...

Sub SaveTest()
Dim TheName
TheName = Range("B2").Text
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs _
Filename:="C:\My Documents\Desired Folder\" & TheName, _
FileFormat:=xlNormal, _
Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub

...where B2 houses the desired file name.

-- courtesy of Half Ace

HTH

-zac
 
Back
Top