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


---
Regards,
Norman


"Mike" wrote in message
...
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