that someone else mentioned, in the background, but
not VBA).
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Sunday, April 29, 2012 10:21 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know
I exprot data from busy in 5 workbook. and now i open 1 workbook wnat
to copy other 4 workbook data in open 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
Hi Anil,
can u share sample sheet with example.
Regards
LAKSHMAN
From: anil kumar kmr7a...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, April 30, 2012 12:35 PM
Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know
I exprot data from
Hello sir,
How r u, there is no need of sample sheet, simply u have 4-5 workbook
of any data.
and now u have to copy all data from 4-5 workbook. than we have to
open 1 by 1 workbook and copy in 1 sheet. now i want to know that can
i open 1 sheet from that 4-5 workbook copy all data in 1 sheet.
Sent: Monday, April 30, 2012 6:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know
Hello sir,
How r u, there is no need of sample sheet, simply u have 4-5 workbook
of any data.
and now u have to copy all data from 4-5 workbook. than we have to
open
@googlegroups.com]
On Behalf Of anil kumar
Sent: Monday, April 30, 2012 12:05 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know
I exprot data from busy in 5 workbook. and now i open 1 workbook wnat
to copy other 4 workbook data in open workbook
Hello sir,
First of all thanks, secondly I don't know vba so can't use it. is excel
have any formula. plz tell me.
Thanks Regards
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
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 and