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

  • Thread starter Thread starter SeanMagoo
  • Start date Start date
S

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
 
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
 
Back
Top