Function to replace FollowHyperlink() in VBA. Handles security warnings, special characters in file name, return value. Did you try opening the page using Shell Function? en-us/vba/language-reference-vba/articles/shell-function. Hyperlink Method (Access). The FollowHyperlink method opens the document or Web page specified by a hyperlink address.

Author: Vudozahn Daizahn
Country: Philippines
Language: English (Spanish)
Genre: Love
Published (Last): 8 August 2018
Pages: 332
PDF File Size: 9.46 Mb
ePub File Size: 7.38 Mb
ISBN: 698-7-51707-970-7
Downloads: 8554
Price: Free* [*Free Regsitration Required]
Uploader: Zolokora

Read about this change in our blog post.

A String or byte array that specifies additional information for HTTP to use to resolve the hyperlink. But, the Wal Mart link also requires login credentials and does work.

Excel VBA FollowHyperlink Method

Did you try opening the page using Shell Function? Sign up using Facebook.

Works like a charm. Login Login with twitter. Stack Overflow works best with JavaScript enabled. In order to post comments, please make sure JavaScript and Cookies are enabled, and reload the page. A Boolean value where Followhyperlinnk adds the hyperlink to the History folder and Followhyperlimk doesn’t add the hyperlink to the History folder. You don’t need to include the question mark when you specify the extrainfo argument.


The code is simple: He is also a: Wyman is a Human Resources professional based in Hong Kong, specialized in business analysis, project management, data transformation with Access and Excel.

Application.FollowHyperlink method (Access)

For example, you can supply parameters to a search engine. This hyperlink may be supplied by you or by the user.

I did have to change the path as this is running on I know ExtraInfo Optional Variant A string or an array of Byte data ofllowhyperlink specifies additional information for navigating to a hyperlink. The location within the target document. Example The following function prompts a user for a hyperlink address and then follows the hyperlink: As the Sub procedure runs, browser will open. The default is False. Click here for instructions on how to enable JavaScript in your browser.

Excel VBA FollowHyperlink Method –

True to display the target application in a new window. I’m fairly certain login credentials are the issue but I’ve no idea how to go about making this work. Glad to be of help!


Sign in to give feedback. By default the headerinfo argument is a zero-length string.

Sign up or log in Sign up using Google. The default value is the empty string. I realize you fine folks can’t test the link as it requires login info I can’t give out. Followhyperkink Adrian 1 By using the FollowHyperlink method, you can follow a hyperlink that doesn’t exist in a control. SubAddress Optional String A string expression that evaluates to a named location in the document specified by the address argument.

FTR I’m already logged into both sites prior to executing the command. Post Your Answer Discard By clicking “Post Your Answer”, you followhyperlin, that you have read our updated terms of serviceprivacy policy and cookie policyacceds that your continued use of the website is subject to these policies. The default is True.