Page 1 of 1
Excel
Posted: Fri Aug 05, 2005 9:19 am
by crazycaddy
Where could I find an application/macro that can merge multiple execl spreadsheets together?
but on the same sheet.
Posted: Fri Aug 05, 2005 9:23 am
by feyd
....on a windows server?
You should be able to use Excel itself if it's installed..
Posted: Fri Aug 05, 2005 9:34 am
by crazycaddy
how? There is about 1000 excel documents with the same layout, but i want the data all in one sheet.
Posted: Fri Aug 05, 2005 10:40 am
by feyd
if it's a windows server, and Excel is installed, you can use
COM to open each file and dump each into a single file.
Posted: Tue Aug 09, 2005 4:01 am
by crazycaddy
could you please give an example script? its fairly urgent.
Posted: Tue Aug 09, 2005 8:11 am
by feyd
sorry, I can't. None of my work goes on windows servers much.
Posted: Tue Aug 09, 2005 10:42 am
by crazycaddy
OK no problem, I found a program called filemonkey to merge txt files, and another program costing around £11 to convert the xls documents to txt (most programs like that are either $40 for 3 months or $399 as a one of payment

)