thanks ashish but i dont want to open it coz file is on server and it takes lots of time to open n close. so is there any way to reduce opening and closing time? file size is in few KB but it takes 1 min to open n close the file.
> >From: ashish koul <koul.ash...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Tue, 5 July, 2011 1:32:58 PM >Subject: Re: $$Excel-Macros$$ copy data without opening file > > >i suggest you hide the workbook from which you are copying the data if you >dont >want to show it to the user > > > >http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba > > > > >On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma <rajanverma1...@gmail.com> wrote: > >No, We cant Copy the data from Closed Workbook.. but we can get the Data by >Using Full Reference of cell .. Like >> >>='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1 >> >> >>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On >>Behalf Of ankur >>Sent: Tuesday, July 05, 2011 12:13 PM >>To: excel-macros@googlegroups.com >>Subject: Re: $$Excel-Macros$$ copy data without opening file >> >>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 >> > > >-- > >Regards > >Ashish Koul >akoul.blogspot.com >http://akoul.posterous.com/ > >akoul.wordpress.com >My Linkedin Profile > > >PBefore printing, think about the environment. > -- >---------------------------------------------------------------------------------- > >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
<<~WRD000.jpg>>