Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook, worksheet rename
Your kind assistance please.
I asked a similar question yesterday and received a number returned messages. These messages did help considerably but due to a lack of my knowledge of excel VBA I am still struggling with this problem. I have been given the task of renaming over 400 hundred workbooks. To complicate matters, each workbook has a single worksheet this also needs to be renamed. All have to be given a unique name of various lengths. I have been working on a system that would produce a list of all workbooks (from a specified folder) in Column A. Column C would show the respective worksheet (each workbook only ever has one worksheet). When the list has been produced, I would then like to enter the new name in Column B for each workbook and in Column C enter the new for each worksheet. Each would then be updated accordingly. Has anybody worked on such a system. If you have and can help I would appreciate it. Regards PW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rename workbook that I am editing without saving? | Excel Discussion (Misc queries) | |||
How to open a new workbook and rename the workbook? | Excel Discussion (Misc queries) | |||
rename a group of spreadsheets in a workbook | Excel Discussion (Misc queries) | |||
Auto Rename Excel Sheets in Workbook | Excel Worksheet Functions | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions |