Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Give a sheet a name from data in a cell-saving to a specific folde
I have a blank worksheet (call it no name) and want to use the data in cell
E11 (e.g.data could be 18208C) to rename the worksheet (eg to 18208C) I then want to save the workbook with the same name as the new worksheet's name (ie as an example still 18208C) in a subfolder of a Folder called Jobs on my C drive. The proviso is that the subfolder name within the Jobs Folder is always the first 3 digits of a workbook name & if the Subfolder Name (ie in this example 182) within the Jobs Folder doesn't already exist I need to create a new one using those three digits before saving the workbook Thanks again |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can DSUM give me specific data? | Excel Discussion (Misc queries) | |||
Give a sheet name from a Cell | Excel Worksheet Functions | |||
How to position to a specific sheet before saving | Excel Programming | |||
How to get specific cell data from one sheet! | Excel Programming | |||
Send data from userform to specific cell on specific sheet? | Excel Programming |