+ Reply to Thread
Results 1 to 10 of 10

Hyperlink to Other Active Workbook

  1. #1
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Hyperlink to Other Active Workbook

    Want to create a hyperlink to the next open workbook, first sheet. (name is different every time I run a macro)
    This code works but for the sheet inside the current (first) workbook but not what Im looking for. I want it to link the first sheet in the next open workbook. I have another one open (second workbook) next to this one. Something with activewindow next ? The link has to be in the first sheet of first workbook.
    Thanks!

    3f.xlsm

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Hyperlink to Other Active Workbook

    So far I have this:

    Please Login or Register  to view this content.
    But its not working, something with subaddress I think cus its making the hyperlinks name: True - (filename)

  3. #3
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Hyperlink to Other Active Workbook

    Why doesnt this code work? : vba object does not support this property or method

    Please Login or Register  to view this content.
    Last edited by IKZOUHETNIETWETEN; 01-21-2014 at 06:40 PM.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Hyperlink to Other Active Workbook

    Workbooks don't have a Hyperlinks collection/property.

    By the way, why do you need the hyperlink if you are activating the next workbook in the code?
    If posting code please use code tags, see here.

  5. #5
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Hyperlink to Other Active Workbook

    I tried that to set the second workbook but I think i could delete that line. Shame it doesnt support it, my second code almost worked, showed the path and all, just couldnt open it. Guess I need to copy paste.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Hyperlink to Other Active Workbook

    You need to specify the cell you want the hyperlink in.

  7. #7
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Hyperlink to Other Active Workbook

    I want the hyperlink in A1 in wb1, how do I fill that in here? Cus now its showing the hyperlink in wb2, A1. For the rest this one seems to be working, just wrong wb
    If I delete the activatenext, then its showing the hyperlink in wb1, a1, with the link to wb1. Its gotta be hyperlink in wb1, a1, linked to wb2.

    Please Login or Register  to view this content.

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Hyperlink to Other Active Workbook

    Instead of ActiveSheet use wb1.ActiveSheet.

  9. #9
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Re: Hyperlink to Other Active Workbook

    Hmm didnt work, I get wb1 name in wb1, a1. I tried this and this works, switching with windows twice:
    Thanks anyways! +rep

    Please Login or Register  to view this content.

  10. #10
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Hyperlink to Other Active Workbook

    Did you try the hyperlink?

+ 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. VBA macro for hyperlink to active workbook in the active workbook path
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2013, 05:37 AM
  2. Macro to Print active sheet as PDF to Active workbook and customize name
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 08:52 PM
  3. Inserting and Removing Hyperlink within active Workbook
    By Bhummel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2012, 08:37 AM
  4. how can worksheet_activate event of active sheet work of active workbook
    By tahir mahmood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2011, 08:19 AM
  5. Hyperlink selected cell to last worksheet in active workbook.
    By Mr.G. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2009, 05:45 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