Hi Ankur, this is FANTASTIC. thanks a lot.
> >From: ankur <ankurpande...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Tue, 5 July, 2011 12:16:06 PM >Subject: Re: $$Excel-Macros$$ copy data without opening file > >check this also >one sample file and explanations is given >http://www.vbaexpress.com/kb/getarticle.php?kb_id=454 >Have A Nice Time & Enjoy Life > >Regards: >CMA Ankur Pandey >(Someone Different) > >I'm not the best but i'm not like the rest~~ > > > >On Tue, Jul 5, 2011 at 12:13 PM, ankur <ankurpande...@gmail.com> wrote: > >hi hanumant >> >>you may find this to be useful >> >>http://spreadsheetpage.com/index.php...a_closed_file/ >>Have A Nice Time & Enjoy Life >> >>Regards: >>CMA Ankur Pandey >>(Someone Different) >> >>I'm not the best but i'm not like the rest~~ >> >> >> >> >>On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde <arsfan2...@yahoo.co.in> >wrote: >> >>Hi friends, >>> >>>is there any way where we can copy data from closed workbook "A" and paste it >>>into workbook "B" which is open? >>> >>>-- >>>---------------------------------------------------------------------------------- >>> >>>Some important links for excel users: >>>1. Follow us on TWITTER for tips tricks and links : >>>http://twitter.com/exceldailytip >>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>3. Excel tutorials at http://www.excel-macros.blogspot.com >>>4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>>To post to this group, send email to excel-macros@googlegroups.com >>> >>><><><><><><><><><><><><><><><><><><><><><><> >>>Like our page on facebook , Just follow below link >>>http://www.facebook.com/discussexcel >>> >> > -- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel