OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Combine more than two Calc files into a single master file

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Code Snippets
View previous topic :: View next topic  
Author Message
ds.sundar
General User
General User


Joined: 25 Oct 2005
Posts: 34

PostPosted: Wed Nov 23, 2005 4:42 am    Post subject: Combine more than two Calc files into a single master file Reply with quote

Hi guys

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.

SUNDAR
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Code Snippets All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group