Joined: 25 Oct 2005
|Posted: Wed Nov 23, 2005 4:42 am Post subject: Combine more than two Calc files into a single master file
I have to combine some 10 to 20 excel file into a single master file. Each and every file has some 20 to 30 spreedsheets. Can anybody give me a macro to do this. i am new to Oopen office and also to programming. I am not so much expert.
Now i open each and every file and copy paste it into a newly created master file.
After some search in the net i got a link http://www.ooomacros.org/user.php to combine file. it is exactly as same as i want. but it combines only doc file and not the Excel spreedsheets.
So please anybody help me by providing a macro to combine more than two file in a single click
Thank You very much in advance.