Click here to Skip to main content
15,890,690 members
Articles / Programming Languages / VBScript

Merge Many Excel Files into one VBS

Rate me:
Please Sign up or sign in to vote.
4.13/5 (7 votes)
14 Jul 2020CPOL 22.6K   367   2  
This VBS will merge Many Excel files into one
This MergeExcel.vbs will merge Many Excel files into one. Double click to run it. It will read MergeExcel.txt file located in the same folder and imports all worksheets into one workbook.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer
United States United States
Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.

Comments and Discussions