merging csv files into a single xls file

**RezDan** · 04-05-2012, 08:16 PM

Hi,
I have 5 csv data files called a.csv, b.csv, c.csv, d.csv, and e.csv. All of these files have the same structure. Is there a way to merge these files into a spreadsheet with a.csv, b.csv, c.csv, d.csv, and e.csv as 1st, 2nd, 3rd, 4th, and 4th sheets, respectively. I am using open office calc and don't want to merge the files manually anytime I create them. Any reply is appreciated.

Regards,
Reza

**abousetta** · 04-05-2012, 08:22 PM

Hello and welcome to the forum. If I understand you correctly, you want to automatically pull each csv file into a new worksheet, but not all five csv files into one excel worksheet.

This can be done with vba, but if you want to implement this in OpenOffice, you will need to know the equivalent object names used in that program. I personally tried to use code that works fine in Microsoft Excel directly in OpenOffice and it errored everywhere. If you don't find anyone here with experience writing macros for OpenOffice then I would suggest you post this question in an OpenOffice forum.

Good luck.

abousetta

**RezDan** · 04-05-2012, 10:09 PM

Hi abousetta,
Thank you for your reply. Actually, I would like to have all 5 individual csv files in a single excel spreadsheet.

Regards,
Reza

**abousetta** · 04-05-2012, 11:33 PM

Hi,

This will bring in all the CSV files in a folder into the activesheet of Excel. Let me know if you have any questions.

Please Login or Register  to view this content.

**windslayer** · 06-03-2012, 01:48 PM

hihi abousetta;
i love your script...
I encounter the similar problem before, and after using the code;
it work...

btw the way; what if i only want to import the data Starting from row 11 onward?

i need to merge all the csv file but my data needed start from 11th row onward..
please help me as i still a beginner in VBA.

Can anyone with similar expertise give me a hand?

**arlu1201** · 06-03-2012, 02:16 PM

windslayer,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.