Script To Extract Excel Sheets

Hi,

PLEASE READ DETAILS BEFORE BIDDING. PLEASE!
Project Details:
I have a folder with 400-600 excel workbooks. Every workbook has a sheet named “XYZ”. I would like to create a script to extract sheet “XYZ” from all the workbooks. I prefer VB script but let me know what is best. The folder will be on Windows OS.

Challenges:
1. Some workbooks might have spelling errors so I should be able to modify the script and run it again so you are expected to show/teach me the whole script and you …

Leave a Reply

Your email address will not be published. Required fields are marked *