+ Reply to Thread
Results 1 to 4 of 4

Links to other workbooks??

  1. #1
    Registered User
    Join Date
    05-09-2008
    Posts
    2

    Links to other workbooks??

    Can you create links in one workbook to open up other workbooks? Is there a formula so when you click on a cell, it opens up the desired spreadsheet? If so, How?

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon mattcross55
    ...and welcome to the forum!!
    Quote Originally Posted by mattcross55
    Is there a formula so when you click on a cell, it opens up the desired spreadsheet?
    No there isn't. A formula is passive and can do no more than return a value. However, you could use a macro to run through the LinkSources object and open each workbook it finds in there. Use the macro below to do this :

    Please Login or Register  to view this content.
    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Create a hyperlink

    If you create a hyperlink and hyperlink it to the file, when you click on it the second file will open. This works on any type of file PDF, DOC Etc.
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  4. #4
    Registered User
    Join Date
    05-09-2008
    Posts
    2
    Thanks very much for that. Just tried it out and my boss got so exited he's told me to spend the rest of the day setting up hyperlinks. Thats got pay rise written all over it.

    Nice one friend.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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