Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from multiple workbooks and display the original worksheet na | Excel Discussion (Misc queries) | |||
copy range to multiple workbooks | Excel Discussion (Misc queries) | |||
copy text between 2 open workbooks via macro | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) |