Description
Program used to merge or compile numerous Excel files into a single file all with a single header.Specifically written for Dr. Amy Cantrell's STA2023 and expanded for general compilation of Excel Surveys and merging of Excel Files.
Credits
Special Thanks to Yap Chun Wei. He created the Excel class template I use to access and compile excel files.
Usage
Run the Program and use the "Select Directory" ListBox to navigate to the directory containing the excel files to merge. Double Clicking the directory desired opens that directory and displays subdirectories.
- [..] Double Click this to move up one directory
- [directoryname] Double Click this to navigate to this directory
All Excel files contained in the current directory are displayed in the ListBox on the Right.
Click the "Browse" button at the bottom of the screen to select the ouput file to save to.
Click the compile buttom to merge/compile the files.
Output
The ouput is a text file (due to problems with writing and Excel File). Simply open the Text file in Excel by Clicking "File->Open" and selecting "*.txt" from the drop down list at the bottom of the Open File Dialog.
The Wizard that opens up will as you if you want to use any special formating. The output file is "Delimited" with "Tab"s. Simply click finish to import the text file and save the file in a Excel Format.