| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop thru files in DIR, delete worksheets & reset worksheet Name property??
Can anyone share idea(s) for code that will programatically loop
through all the .xls files (each file has 10 worksheets) in a directory and 1) delete the same four worksheets ("Sheet1", "Sheet10", "Sheet3", & "Sheet6" from each of the .xls files, and then 3) change the worksheet Name property of the remaining six worksheets so that the worksheet Name property of the first worksheet is "Sheet1", the second worksheet is "Sheet2", etc. Any ideas are greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reset the range of FOR loop | Excel Discussion (Misc queries) | |||
| Is it possible to reset the starting cell in a For Loop | Excel Discussion (Misc queries) | |||
| Loop thru multiple files - Modify worksheet visible property | Excel Programming | |||
| Excel macro to loop through worksheets and graph data from each worksheet | Excel Programming | |||
| Is there a Sheet delete property? | Excel Programming | |||
Threaded Mode
