how to combine several files, all with same columns, into one shee

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Ron,
The column may have a blank row in it. When I use the macro it stops at the
blank row and moves to the next file. Sometime the blank row is in the middle
of the file. Is there a way for the macro to skip the blank row and continue
copying the rest of the column?
 
Bernie's code works for me but I have two questions:
It works in a new worksheet (as directed) when I tried to move it to
Personal.xls, I can't get it to work. It runs with a blank result. Is this
pilot error or is there a fix?

Can the code be modified to combine .csv files?
.FileType = msoFileTypeExcelWorkbooks
=msoFileTypeCoomaSeparatedValues. N/G

Thanks for your help. A great resource.
wal50
 
Worked like a charm. Thanks again to you and all the other wizards who make
the lives of mere mortals that much easier.
wal50
 
Great Ron,
Entering A2 in startCell will remove any header. But what if I need to keep
the header to be in the first row of the new sheet and not repated from every
file I combine?
 
In the process of helping clients manage their spreadsheets I have developed
a web application that loads, organizes and reports upon a portfolio of
spreadsheets.
This application is not yet being offered as a "product" or "service" but I
invite you to check it out at http://www.spreadsheetmanagement.com/
I may be able to help you extract the information you need.
 
Hi Ron

I have run the RDB Merge Ad-in, to merge 95 Excel files. There is just 1
problem, it merged the files and data, but the fill colours of the cells are
now "no fill" and that is the most important part of my merge! How do I do
the merge and make sure that the cell fill colours are also duplicated?

Thanks
Babs
 
Dear Bernie,
Great work.
Please help me that how to save this macro, Do I have to paste again and
again..
 
Back
Top