| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error when already same name / Macro save as cell contents | Excel Discussion (Misc queries) | |||
| 3 text lookup tables use to define contents of a cell | Excel Worksheet Functions | |||
| Using the numeric contents of a cell to define row number | Excel Worksheet Functions | |||
| How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Linear Mode
