using a macro to define the contents of a cell as the save as name

[SeanMagoo]

I have written an excel sheet for various users to use at
the same time, I am trying to use a macro to define the
contents of a cell (persons name) and get the save as box
to save the file as this name, Is this possible to do and
has anyone any Ideas pleas

 

[David McRitchie]

Hi Sean,
You don't need to pick up the username from a worksheet cell.j

Userid / machine name / identity / properties
http://www.mvps.org/dmcritchie/excel/userid.htm


How to create SaveAs dialogue box with a macro?
reply by Pattrick Molloy

Dim fn As String
fn = Application.GetSaveAsFilename
ThisWorkbook.SaveAs fn