Join serveral Excel files to one file (Exports to csv via COM)

Post your working scripts, libraries and tools
Acuena
Posts: 20
Joined: 27 Jan 2014, 14:56

Join serveral Excel files to one file (Exports to csv via COM)

16 Apr 2018, 06:36

Hi all!

I haven recently been working on a script to merge several Excel files to one big. Havent found any free software to do this so i made my own.
It uses Excel COM to re-save all Excel files in the selected folder into CSV-files.

It then generates a bat file the user have to run.
All code is there and is free to use and modify, just plz mention here if you do.
Find any bugs or have a improvment? Let me know :D

Anyhow, here is the code (80 lines of code, could possible be shortned :P)

Code: [Select all] [Expand] [Download] GeSHi © Codebox Plus

Return to “Scripts and Functions”

Who is online

Users browsing this forum: No registered users and 14 guests