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

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

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

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"SeanMagoo" wrote in message ...
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