User Profile
RoderickSullivan
Copper Contributor
Joined 8 years ago
User Widgets
Recent Discussions
Re: Excel hyperlink default software to open FileName .pdf
Further to our discussion, I recently had cause to uninstall the Default App I use to open .PDF files and then to re-install it. As a result the problem I was have with Excel Hyperlink not using my chosen default App is now fixed and all works as it is supposed to.926Views0likes0CommentsRe: Excel hyperlink default software to open FileName .pdf
RoderickSullivan Further to our discussion, I recently had cause to uninstall the Default App I use to open .PDF files and then to re-install it. As a result the problem I was have with Excel Hyperlink not using my chosen default App is now fixed and all works as it is supposed to.909Views0likes0CommentsRe: Excel hyperlink default software to open FileName .pdf
NikolinoDE Hi How am I going - trying ? I am at the end of my knowledge when I get to your VBA solution. What does the Shell32.dll do and what are the arguments that are being pased to it? Since there is closing bracket to the funcction declaration , are ther more arguments? Is the function What is the significance of the “0” and the “1” in the OpenPDF sub? My problem is making an excel hyperlink that I create in my excel file use my chosen PDF software. Is the code intended to open my PDF App and using this dll file is the way to do this in VBA? Your REGISTRY SETTINGS notes yield the following Screen shots. 1, 2, 3 4 5 Shell Settings Next!1.8KViews0likes4CommentsRe: Excel hyperlink default software to open FileName .pdf
NikolinoDE Hello and thank you for your reply. I had tried everything you suggested above Step 4 and nothing worked. So, I turned to Co-Pilot and asked what might be causing excel to ignore the default pdf setting. This led me to shell settings. I was getting outside my knowledge here so I did not proceed but posted my POST instead. I have used VBA and built functions so have some expertise in this area but, your coding is pushing me a bit. I will do some more work in this area as time allows. If I come up with anything useful I will let you know. Thanks again!2.1KViews0likes6CommentsExcel hyperlink default software to open FileName .pdf
A hyperlink to a ".pdf" type file is created in an excel cell. Clicking on this hyperlink opens the file. The problem is that the default software to do this is Adobe Acrobat not the default software I have set in my Settings > Apps > Default Apps. It seems that Excel has a mind of its own when it comes to this function/action (Opening a Hyperlink to a ".pdf " file elsewhere in the computer). This is a new recent problem as for many years the default setting was always used. How to get excel to use the default software as it used to do? Help please!2.4KViews0likes8Comments
Recent Blog Articles
No content to show