LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nc
 
Posts: n/a
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy from multiple workbooks and display the original worksheet na Barb Reinhardt Excel Discussion (Misc queries) 1 October 5th 05 03:51 PM
copy range to multiple workbooks davez Excel Discussion (Misc queries) 4 August 27th 05 01:14 AM
copy text between 2 open workbooks via macro bigdaddy3 Excel Worksheet Functions 2 August 18th 05 06:37 PM
reminder notifications in a column L Mieth Excel Discussion (Misc queries) 6 June 10th 05 11:00 AM
How do you point to a named range in linked workbooks? KG Excel Discussion (Misc queries) 5 February 18th 05 09:55 PM


All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"