![]() ![]() FileProtocolHandler APIĪnother option is to use the FileProtocolHandler API. That said, for me, this lead me to start exploring what other options existed and that is for where the rest of this article originated from. Disable “Hyperlinks can be harmful to your computer and data” Message in Office 2016.Enable or disable hyperlink warning messages in 2007 Office programs and in Office 2010 programs.Now there are ways to deactivate such messages, but the you get into hacking the registry and not everyone has the necessary permissions, … Should wish to explore this more, feel free to look over: To protect your computer, click only those hyperlinks from trusted sources. Hyperlinks can be harmful to your computer and data. The only problem being that depending on Microsoft’s mood, registry settings, … some users will get the following warning which can be alarming to some: 'OpenURL1 "C:\Users\Microsoft\Documents\Image.jpg" -> launches in system default app 'OpenURL1 "C:\Users\Microsoft\Documents\Test.pdf" -> launches in system default app In one simple line of code, as shown below, you can open any file or URL in the user’s default associated application. In Access, the easiest technique to open a file or navigate to a URL is to simply use the Application.FollowHyperlink method. In this article I will attempt to explore multiple appraoches that can be used to open files and URLs using VBA, the choice of which one to use is left to you to decide! That said, I will expand on: Before going any futher, have you seen my previous post regarding opening a URL in the browser of your choice enttitled VBA – Open a URL in FireFox/Chrome, check out the section entitled ‘ A Procedure to Control Them All!‘ So what does a developer do when he can’t sleep? He explores what options can be used to open files and/or URLs, of course!
0 Comments
Leave a Reply. |