Click here to Skip to main content
15,899,935 members
Articles / Programming Languages / VBScript

Merge many Excel Worksheets into one using VBS

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
4 May 2020CPOL 7.8K   66   2  
This VBS will merge Many Excel Worksheets into one.
This MergeSheets.vbs will merge Many Excel worksheets into one. Drag and drop an Excel file on top of this script file to merge worksheets. The first data row must contain column names.

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