Combining Excel worksheets

[Guest]

I have 225 Excel files, each with one worksheet, all with exactly the same
colums and headings. Is there a way to combine all 225 worksheets into one
long single worksheet? I need this to export to an Access table.

I also have a workbook with 35 worksheets that should be combined into one
worksheet, for the same reason.

thanks,
Mike

 

[Norman Jones]

Hi Mike,

Ron de Bruin has sample code at:

http://www.rondebruin.nl/tips.htm

See, for example:

http://www.rondebruin.nl/ado.htm

http://www.rondebruin.nl/copy3.htm

And, for your second task, see:

http://www.rondebruin.nl/copy2.htm


If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Bill Ridgeway]

If you were to export your worksheets as CSV files into Access you would
save the effort of combining all your files just to export the data. Just
an idea that may work!

Regards.

Bill Ridgeway
Computer Solutions