Copy a range from closed workbooks (ADO)

[nc]

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.

 

[Ron de Bruin]

Hi nc

Change the xls to csv in the code

 

[nc]

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]

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

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