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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a Name's Contents 8
Name a range using cell contents 2
Macro to save contents of a named range to a file 7
using defined name in UDF 7
Save it giving as a name the content of a cell 3
Macro using relative cell reference to set name for range 4
SAVE AS MACRO 5
Modifying a Defined Name's Contents 10

Back
Top