+ Reply to Thread
Results 1 to 7 of 7

HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Omaha, Nebraska
    MS-Off Ver
    2010
    Posts
    39

    HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    Okay,
    This is an odd one. Is there any way to:
    Create an outlook reminder (already done, code below) that, in the body, has a hyperlink to an already open workbook on a specific sheet without asking to reopen the workbook?
    I have the workbook and the add reminder code (posted below).
    Clearly, the line in question is "objAppointment.Body="
    Thanks in advance for your help.

    Darren

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    I'm not sure there is anyway around it. Perhaps you could create the hyperlink to a personal.xlsb that has code in it to make the workbook thats already open the active workbook?

    Just brainstorming.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    12-03-2012
    Location
    Omaha, Nebraska
    MS-Off Ver
    2010
    Posts
    39

    Re: HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    Great Brainstorming.
    Yeah, I was pretty sure of the answer to that one out of the gate, but didn't want to flat out say I didn't think it was possible, as there are way to many brainiacs in here to prove me wrong.
    I like your thought process though. Essentially, a macro would run when the new workbook is opened. However, there would be no redirect to the correct file from the personal.xlsb as there would be no code transferred over from the reminder making it more work than it is worth.

    It's a great idea in theory (the whole outlook reminder taking you straight to the page---thing), but I guess it's not going to worth the end result of "sketchy at best."

    Thanks for the effort/input SOLUS!

    Have a great day.

    Darren

  4. #4
    Registered User
    Join Date
    12-03-2012
    Location
    Omaha, Nebraska
    MS-Off Ver
    2010
    Posts
    39

    Re: HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    This was an erroneous double post.
    Last edited by Dabbler39; 08-18-2013 at 08:10 PM. Reason: double post?(HOW?)

  5. #5
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    Does the reminder point to the same workbook every time?

  6. #6
    Registered User
    Join Date
    12-03-2012
    Location
    Omaha, Nebraska
    MS-Off Ver
    2010
    Posts
    39

    Re: HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    Same workbook, just a different sheet each time. Each sheet is a different "client". As such, the reminders involve doing something for that particular client (that sheet in the workbook) each time. That's why I wanted the link to just take you to the sheet in the workbook where the activity is planned. Rather then having to go to the reminder when it pops up, closing and/or deleting the reminder, then going back into the workbook and searching for the client/sheet relating to the reminder.

    Did any of that make sense? Just ate, so I am in a bit of a food coma right now.

    Thanks again,

    Darren

  7. #7
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: HYPERLINK in an outlook reminder to an ALREADY OPEN workbook

    It makes perfect sense. Still trying to figure out how to work a sheet variable into the code...

+ 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. Setting a Reminder in Outlook via Excel
    By yka in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2018, 01:05 PM
  2. Creating a reminder in excel and having a pop up in outlook
    By nazismart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2013, 04:58 AM
  3. Open excel workbook from Outlook UserForm
    By NewGuy OnBlock in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2011, 11:03 PM
  4. Set reminder when importing into Outlook
    By Victor in forum Excel General
    Replies: 0
    Last Post: 08-04-2006, 12:10 PM
  5. [SOLVED] can i have a pop up reminder message when i open a workbook?
    By j jones in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-16-2005, 04:10 PM

Tags for this Thread

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