+ Reply to Thread
Results 1 to 9 of 9

Link (closed)workbook to (open)workbook

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Link (closed)workbook to (open)workbook

    The Morefunc add-in will allow you to use the "=INDIRECT" function to reference closed workbooks.

    http://www.ashishmathur.com/tag/morefunc/

  2. #2
    Registered User
    Join Date
    07-08-2014
    Location
    Iceland
    MS-Off Ver
    2013
    Posts
    7

    Re: Link (closed)workbook to (open)workbook

    Quote Originally Posted by hoyasaxa215 View Post
    The Morefunc add-in will allow you to use the "=INDIRECT" function to reference closed workbooks.

    http://www.ashishmathur.com/tag/morefunc/
    Other users need to be able to use it.
    If they don't have the add-in then will it work?

+ 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. [SOLVED] Copying data from a closed workbook into an open workbook ignoring excel filter?
    By reach78 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-17-2013, 12:31 AM
  2. Search for a value in closed workbook and paste adjacent cells to open workbook
    By jmapark91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2013, 10:54 AM
  3. Macro to open a closed workbook and select copy cells into an open workbook
    By helloganesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 02:00 PM
  4. [SOLVED] Copying specific rows from an open workbook into the next row of a closed workbook.
    By Deimola in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2012, 12:59 PM
  5. retrieve object from multiple closed workbook and paste into open workbook.
    By niailmar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2012, 12:31 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