hi,
i am getting links from other workbook to make monthly report using below code
but above code takes too much time get link form closed workbook,Please Login or Register to view this content.
need a faster and light code
hi,
i am getting links from other workbook to make monthly report using below code
but above code takes too much time get link form closed workbook,Please Login or Register to view this content.
need a faster and light code
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Hi HaroldSid,
I do not believe that you can greatly improve the speed of the code.
However, be aware that you may use the way of unique fixed vectors for a single cell over an extended range, ( in a closed workbook reference ) ( https://www.excelforum.com/developme...ml#post4626713 )
This would allow you for example to replace these two lines_..
_.. with this one linePlease Login or Register to view this content.
Note Importantly in that last line you are using relative referencing for column D ( You must omit the $ )Please Login or Register to view this content.
After execution of the last code line, the formulas appearing would look like this: ( For i=2 )
Using Excel 2007 32 bit
Row\Col O P 2 ='Z:\42766\Jan 2 Dec 2014\1.12.16\[WotEverWasInCelD2.5.17.xlsb]SUMALL'!D$3 ='Z:\42766\Jan 2 Dec 2014\1.12.16\[WotEverWasInCelD2.5.17.xlsb]SUMALL'!E$3
That might give a very small improvement in time if you apply that to all the lines where you have two adjacent cells
If you can arrange that all your data is in a single rectangular Areas of contiguous cells , then you could replace all your code lines with a single code line
Alan
Ref:
P.M. Richard Buttrey: “Computer workings, Intelligence”
https://www.excelforum.com/developme...ml#post4608252
https://www.excelforum.com/developme...ml#post4605725
https://www.excelforum.com/developme...needed-13.html
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
Thank you very very much @ Doc.AElstein
You is welcome,
Thanks for the feedback and the Rep
Alan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks