when i hit save as, i would like excel to refer to a certain cell on my spreadsheet to name the spreadsheet file. is there a way to do this?
when i hit save as, i would like excel to refer to a certain cell on my spreadsheet to name the spreadsheet file. is there a way to do this?
Isu,Originally Posted by lsu-i-like
With a macro,
Something like;
Asumimg cell you want to use is B2.
Subsitute your path to where you want the file to be saved.
Sub SaveAsFileName()
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Owner\Desktop\" & Range("B2").Value & ".xls"
End Sub
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks