Solved

VBA Visio, Excel, and Word - followhyperlink not working with HTTPS!!!  "=HYPERLINK()" not working in Visio

Posted on 2014-03-11
2
1,145 Views
Last Modified: 2014-03-25
Uggh!  Help.  I tried to insert a url into FOLLOWHYPERLINK in VBA (visio) and it's not working.

Because of security reasons, I have not put the actual URL here but it looks something like this:
https://abc.corp/share/page/site/it-department/documentlibrary#filter=path%7C%2FEnterprise%2520Applications%2FSalesforce%25202.0%2FORG%2520Starr2%2FTechnical%2520Specifications%7C&page=1

The URL works fine when I paste it into the address line.  
The URL does not work when I am in Visio and use it in the HYPERLINK field.
The URL does not work when I am in Excel and Insert/hyperlink in a cell.
The URL does not work when I am in Word and Insert/Hyperlink.
Here's the error I get.  (No, the link is not out of date.)

err
I need to double-click a shape in Visio and then call up a HTTPS web page.
0
Comment
Question by:brothertruffle880
2 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 39923052
Hi,

Maybe you have to work with the sub-address variable of FOLLOWHYPERLINK

see reference
http://msdn.microsoft.com/de-de/library/office/ff766401.aspx

Regards
0
 
LVL 30

Assisted Solution

by:Scott Helmers
Scott Helmers earned 250 total points
ID: 39923588
If you're using the EventDblClick cell, as described in this question, be sure there are no quotation marks around the formula.

That is, be sure the cell contains:
   =HYPERLINK("https://www.xyz.com")
and not
   "=HYPERLINK("https://www.xyz.com")"

The use of https:// vs. http:// should not matter except that a login may be required.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
A short film showing how OnPage and Connectwise integration works.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now