Secure Hyperlink Fails

R

RichW

Problem Statement: Unable to access the content of an https site using
hyperlinks in MS Access, MS Excel and MS Word; for instance:

https://sitename.com/file.pdf

For the url shown above MS Access, MS Excel and MS Word will sent the user
to https://sitename.com

To get to the content (the file.pdf) the following code may be used:

Set myIE = CreateObject("InternetExplorer.Application")
myIE.Visible = True
myIE.Navigate = "<url string>"

In the first example, this code would be setup as:

Set myIE = CreateObject("InternetExplorer.Application")
myIE.Visible = True
myIE.Navigate = "https://sitename.com/file.pdf"

I use a table to store many urls; for this, I use the following code:

Set myIE = CreateObject("InternetExplorer.Application")
myIE.Visible = True
myIE.Navigate Me.tblName

RichW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top