Hi guys,
I'm building a macro with some dynamic hyperlinks to an online protein database: https://www.phosphosite.org. For example, protein "O43399".
From another site, http://www.uniprot.org/uniprot/O43399, I've looked at the link address they provide on their site for this protein which is: https://www.phosphosite.org/uniprotAccAction?id=O43399.
This UniProt link or direct insertion into Google Chrome's address bar gives the appropriate target.
It does so as well when I click from the macro generated formulae:
With Worksheets("Overview").Range("J2:J" & lrr)
.FormulaR1C1 = "=HYPERLINK(""https://www.phosphosite.org/proteinSearchSubmitAction?accessionIds=""&RC[-3],RC[-3])"
End With
BUT, it only works one time. Whenever I click on a second hyperlink, while the first one is open, I get redirected to a useless:
https://www.phosphosite.org/messageA...E0B62236D03072
I have checked with a "redirection" tool yielding; "redirection: type 200 OK"
Other hyperlinks do get redirected to the "proteinSearchSubmitAction?accessionIds=" though, such as:
'.FormulaR1C1 = "=HYPERLINK(""http://www.phosphosite.org/simpleSearchSubmitAction.action?searchStr=""&RC[-3],RC[-3])"
'.FormulaR1C1 = "=HYPERLINK(""https://www.phosphosite.org/proteinSearchSubmitAction?accessionIds=""&RC[-3],RC[-3])"
with RC[-3] = O43399
Again, typing the link address directly in Chrome, or with "CMD> start [+ address]" give me the desired page.
Anyone who does know how to avoid this "sessionid" thing, a CMD workaround with clickable hyperlinks (please no .BAT files), or another way?
Thank you already for reading,
Max138
Post scriptum: added a severely simplified version with hyperlinks, but it does the trick...or doesn't actually
Bookmarks