VBA code To Merge All .csv files into a single excel sheet (data start from row 11th)

W

windslayer

Hi All VBA experts:
I have 1000+ data files stored in csv. All of these files have the sam
structure& format.
I use a vba code written by abousetta

To merge it into one spreadsheet automatically, but the problem is,th
data i needed start only from row 11 onward.
Is there a way to modify the code to allow this to happen?

Here's my requirement on the code:
1) Must be able to merge all the file csv file in on shoot,
2) Data needed start from 11th row onward,
3) after open each file, copy the data from 11th row and onward, cop
and paste it into MasterCSV sheet, the next data will be paste to th
same column but next row to the previous data copied...

I attach one of my file into the thread...
 
A

Auric__

windslayer said:
I have 1000+ data files stored in csv. All of these files have the same
structure& format.
I use a vba code written by abousetta

To merge it into one spreadsheet automatically, but the problem is,the
data i needed start only from row 11 onward.
Is there a way to modify the code to allow this to happen?

Here's my requirement on the code:
1) Must be able to merge all the file csv file in on shoot,
2) Data needed start from 11th row onward,
3) after open each file, copy the data from 11th row and onward, copy
and paste it into MasterCSV sheet, the next data will be paste to the
same column but next row to the previous data copied...

I attach one of my file into the thread...

Go back to your other thread, the one titled "Excel VBA macro to auto import
new CSV file from fixed directory". (You'll notice that I'm the only person
who replied.) Take a look at the code that I posted there. *ACTUALLY TRY
USING THAT CODE.* If you have questions about that code, REPLY IN THAT OTHER
THREAD.
 
B

Bob Flanagan

We saw your post and realized that with a slight modification, one of
our products could do what you wanted. We just did the modification
so that it is available. The product is the Consolidation Assistant.
With it, you can select your CSV files and specify the rows to include
from the first top of the first CSV file, and then to exclude from all
subsequent CSV file. The link to the Consolidation Assistant's page
is http://www.add-ins.com/consolidation_assistant.htm

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top