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

It use the index of the sheet instead of the sheet name

--
Regards Ron de Bruin
http://www.rondebruin.nl


"nc" wrote in message ...
Hi Ron

Thanks for your reply.

I have tried that but it does not seem to work. What about the two other
points I mentioned are there any solution for them.


"Ron de Bruin" wrote:

Hi nc

Change the xls to csv in the code


--
Regards Ron de Bruin
http://www.rondebruin.nl


"nc" wrote in message ...
Hi

With reference to the code at

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

What changes is required to this code for use,
1. with .csv files
2.files with only one sheet but differrent sheet names
3.data on the sheet without headers.


Thanks.