Solved

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

Posted on 2014-03-11
2
1,129 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 48

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Book Review: Using Microsoft Visio 2010 by Chris Roth   Disclaimer: The author of Using Visio 2010 is a friend and fellow Visio MVP. Whether you’re new to Visio or are upgrading to Visio 2010 from a previous version, you will find a lot to like…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

760 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

19 Experts available now in Live!

Get 1:1 Help Now