Hyperlinks in Excel

[Mr_Phil]

I have a hyperlink in G2. I would like to copy the contents of C2, click the link, and paste the value into the open text box on the search form. I do not have access to the website background code. This is in chrome.

I can do all the above manually. Currently G2 is copied all the way down column G. The value in C is what changes. So I am working on tweaking it. I might just anchor the link in G1 and then copy the text, then click G1 to open the website. If I can get excel or chrome to paste the value that would be great. Anyone ever done this or have suggestions for the best way to go about it?

 

[Rijnsent]

How's your VBA? This sounds like something you could automate with VBA, but will take some time to develop, so the usefullness depends a bit on the number of links and how often you'd need to do this. And I assume that after pasting you e.g. would take some info from that page and paste it back to your Excel? That too can be automated... If you have some examples to share, people round here could maybe help you with some code.

 

[Mr_Phil]

How's your VBA? This sounds like something you could automate with VBA, but will take some time to develop, so the usefullness depends a bit on the number of links and how often you'd need to do this. And I assume that after pasting you e.g. would take some info from that page and paste it back to your Excel? That too can be automated... If you have some examples to share, people round here could maybe help you with some code.

Hi. Thanks for looking.
I'm OK with VBA. I defined a series of hotkeys to do it.
I'm in the cell and ctrl c to copy it
ctrl R now fires a macro to open the web page.
There is an extension for chrome that applies focus to the first fillable field
ctrl V to paste the clipboard item
Alt Tab to switch from Chrome back to excel.
down arrow to the next cell
then repeat.

It isn't elegant and real professionals would laugh but it's been working for several days now. So I am happy.
I do appreciate your time though. Thank you very much.