Look here for a code example
http://www.rondebruin.nl/tips.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"rene" wrote in message ...
I am exporting data to excel, from our MRP system. Once a week, we export
this data. I need a comprehensive database to keep all the data. How do I
merge all worksheets, into one???
Originally, I had the data in access however, I exported it to .xls becuase
I thought it would be easier (silly me).