+ Reply to Thread
Results 1 to 4 of 4

get data using link cell of closed workbook

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Post get data using link cell of closed workbook

    hi,
    i am getting links from other workbook to make monthly report using below code

    Please Login or Register  to view this content.
    but above code takes too much time get link form closed workbook,

    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 *

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: get data using link cell of closed workbook

    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_..
    Please Login or Register  to view this content.
    _.. with this one line
    Please 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 $ )

    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 )

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: get data using link cell of closed workbook

    Thank you very very much @ Doc.AElstein

  4. #4
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: get data using link cell of closed workbook

    You is welcome,
    Thanks for the feedback and the Rep
    Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Link to closed workbook not working
    By bvercher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2015, 04:09 PM
  2. Matching data from closed workbook with open workbook based on cell values
    By kbkrueger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2015, 07:42 PM
  3. [SOLVED] Link (closed)workbook to (open)workbook
    By Jón Ingi in forum Excel General
    Replies: 8
    Last Post: 07-25-2014, 04:18 AM
  4. Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  5. How to link cell format from a closed workbook.
    By gdecker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2014, 03:51 PM
  6. [SOLVED] Formula contains a link to a closed workbook?
    By matt323 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2014, 05:02 AM
  7. 2007 Vba - Copy cell as a link to another closed workbook
    By smirker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 08:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1