is there a way to redirect a hyperlink to a non-default browser ?

I have the following situation. I am in a company environment. I cannot change the default browser. The problem with this situation is that the websites that I access via hyperlinks in Excel run inefficient in the default browser. For that reason I would like that the hyperlinks open in a browser that I specify.

I read here that it is possible somehow to instruct Excel in a VBA to open the hyperlinks in a specified browser. But it is not explained in detail.

If somebody knows how to script that, please explain.
Ideally I want a modified hyperlink that opens in a specified browser. I have already written an add-in that creates these hyperlinks in one column. Therefore I would like to keep the one-column hyperlink structure.

how would that practically look like and work?

Assume I have a spreadsheet with publication references.
Each row is a reference to one paper. Each column contains various information e.g. authors, year, title, abstract
The last column contains the hyperlink to PubMed.
Currently when I click on the hyperlink the PubMed site with the abstract opens in the default browser.
Ideally I would like it that instead the hyperlink opens in the browser of my choice.

Hello, dschmitt

In case of just clicking links from file it could be easier to change the default browser. If it is not possible for some reasons (or just not likely), you may create a button with a link name. This button will trigger a macro, that may activate needed browser and, by method SendKeys, you may open needed page.

Rioran, if I understand you correctly, you are saying that I should create a macro that can be executed from a menu button in the ribbon. That macro will open my browser of choice and open the URL in the active Cell. Meaning that I have to select the cell with the URL before I activate the macro.

I think that will work. Can you give me a sample script? I never used SendKeys.

that works. Thank you. Now I just need to figure out how to get the URL in the active cell into the browser.

Just replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

I am sorry. I was distracted with another work. That's why I didn't notice "Cells(1, 1).Value" in the script. While sidetracked I focused on just opening Chrome.
Thank you very much. The problem is solved.

abousetta, I actually use Scopus. I mentioned PubMed because I thought that more people know PubMed. But, thank you for the information. Who knows, in the future I may have to rewrite my software to retrieve data from PubMed instead of Scopus.

About 4 years ago we ask ourselves how to find KOLs for specific bio research areas. I though that this information could be extracted from any publication DB and that the analysis of the publication data could be done in Excel. KOL publish a lot and are cited a lot. This is how I got started with Excel VBA programming. I could build on a couple semester worth of Turbo Pascal programming which I took 25 years ago. I learned VBA while doing. I am still at the basic level although I wrote a lot of code by now. If you look at all my post you can probably piece together what I was building. Basically I learned VBA from people on this forum. I take this opportunity to thank everybody. This forum is just wonderful.

Based on the KOL Excel add-in I created a Excel VBA add-in that is similar to EndNote. I wanted something that is simpler and better in sharing than EndNote. On top of that I created some text mining VBA macros that allow me to more quickly sort through a large number of publications. This comes in handy when you are trying to determine whether a gene which you just came across in one disease area really has the potential for a new drug target. To determine that you have to look at the whole publication record for that gene/protein. This can be daunting when you are dealing with several hundred to a thousand publications.

What I usually do is I do a gene/protein oriented search in Scopus (html site), can be wide, can be refined, and then export the publications as a CSV file. Subsequently I import the CSV file into Excel and rearrange and analyse the data as needed. I chose Scopus for convenience and legal reasons. It was the best DB available to me.

Sharing the code is difficult because the code is very long. But the code is not difficult. A beginner to intermediate level VBA programmer can write that code. The key was to become clear about what the output data was supposed to be and how it should be presented. All I then had to do was move things around and count. But if you have specific question about how I did certain things I am more than willing to share that information including script.