+ Reply to Thread
Results 1 to 6 of 6

How to use Indirect Function with closed workbooks

  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    22

    How to use Indirect Function with closed workbooks

    Hello,

    as you know, Indirect function does not work with closed workbooks. i tried indirectext macro, but it is very heavy and impossible for working.
    does anybody know solution of mentioned problem. I have excel 2013.

    thanks in advance.

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: How to use Indirect Function with closed workbooks

    Laurent Longre's Morefunc addin has a version that can be used on closed workbooks
    http://xcell05.free.fr/
    Frob first, tweak later

  3. #3
    Registered User
    Join Date
    09-05-2016
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    22

    Re: How to use Indirect Function with closed workbooks

    Dear Neil, thanks a lot.

  4. #4
    Registered User
    Join Date
    09-05-2016
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    22

    Re: How to use Indirect Function with closed workbooks

    unfortunately, http://xcell05.free.fr/ website is closed.

  5. #5
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: How to use Indirect Function with closed workbooks


  6. #6
    Registered User
    Join Date
    09-05-2016
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    22

    Re: How to use Indirect Function with closed workbooks

    it works, thanks!

+ 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. Referencing closed workbooks in an INDIRECT like fashion
    By nigeli in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2015, 03:15 PM
  2. Using Indirect Across Multiple Closed Workbooks
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 05:09 AM
  3. Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  6. Replies: 1
    Last Post: 06-22-2005, 11:05 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