Dear Anil,
Yes it is possible by using odbc connection with the workbook and query to
copy the data from source to destination where source is your 5 workbook
and the destination is your sheet where you want to paste the data.
Regards
Lalit Mohan
On Saturday, 28 April 2012 14:04:43 UTC+5:30,
Try this link and change the code accordingly.
http://www.excelfox.com/forum/f13/excel-excel-data-transfer-without-opening-any-files-source-target-339/
On Sunday, 29 April 2012 02:05:34 UTC+5:30, excelGeek wrote:
Dear Anil,
Yes it is possible by using odbc connection with the workbook
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the