Good Afternoon all,
I have some data that gets exported from an Engineering Design Program with 32 tabs (sheets and chart sheets). I currently have some macros that will remove the unwanted tabs, and a macro that will batch convert the files from an .XLS to an .XLSM.
I would also like ot be able to take the tabs that I actually want (after running macros to delete uneanted tabs) and combine them into a single workbook. Sounds simple but i'm new to the programming arena and I can't figure it out.
So, I am looking to run these macros at same time while workbooks are closed: (if possible)
1) Batch convert .XLS files to .XLSM files.
2) Run Macro to Delete all Charts from Exported Workbooks
3) Run Macro to delete all unwanted Sheets
4) Run macro to rename the SINGLE remaining tab in each sheet the same as the file name.
5) Combine all worksheets in all workbooks in a particular folder into a single workbook.
Sounds simple, and I see many different IDeas ot there, but I just can't put them all together in a single action.
Any help or guidance will be greatly appreciated!
adam
Bookmarks