| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save to folder based on cell value
I have a contract that has a macro that will save to a particular location.
Is it possible to make the save location dependant on the first letter of the save name. Example: Save name "Smith, John" Since the first letter is S, I would like it to save to a folder named "Q-S". Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
save to folder based on cell value
Add a case statement to your macro, with an argument that checks the first
letter of the save name variable, and then sets your folder variable to the appropriate folder "Steve" wrote: I have a contract that has a macro that will save to a particular location. Is it possible to make the save location dependant on the first letter of the save name. Example: Save name "Smith, John" Since the first letter is S, I would like it to save to a folder named "Q-S". Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Hybrid Mode
