| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Save Macro as Cell content
I currently open a workbook that goes to cell A1 which contains a filename
with required filenaming conventions(REPORT NAME_DATE_PG#_MST#). I want the user to be able to edit the cell if the content equals "REPORT NAME_DATE_PG#_MST#". Once they edit the cell and finish populating the worksheet they will close the workbook with the current content on cell A1 as the new filename.xls(Sudbury_012907_PG1_MST003). Also once they have changed the A1 cell content it should lock and not be able be changed again no matter how many times they open it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to save multi lingual content from an Excel file to a CSV fil | Excel Discussion (Misc queries) | |||
| How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
| macro save a file name from a cell in 1st worksheet | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
| Save as using cell content in file name | Excel Programming | |||
Linear Mode
