Copy a range from closed workbooks (ADO)
 

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.

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.

Copy a range from closed workbooks (ADO)
 

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.

Copy a range from closed workbooks (ADO)
 

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.