| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change file name when saved to C drive
I want to change the name of my file "Estimation File" to "Master
File" when I save it to (or if it's already in) my C drive. Sheet1!A1 has a formula that returns either 0 or 1. Following are the conditions: If Sheet1!A1 = 0 and file is in C drive, then no change to file name If Sheet1!A1 = 1 and file is in C drive, then change file name to "Master File" Chane occurs only when the file is saved in/to C drive Thanks for any solution you might have. Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file gets corrupt if saved in one particular drive | Excel Discussion (Misc queries) | |||
| Hyperlinks change when file is saved | Excel Worksheet Functions | |||
| Links to mapped drive change to refer to local hard drive | Links and Linking in Excel | |||
| Combobox Change Event when file is saved as | Excel Programming | |||
| Find links with code; change from G drive to C drive | Excel Programming | |||
Threaded Mode
