vba macro to open a link and save the new link in excel

Hi All,
I have a links in a column A and new link to be copied in column B.

I just want that, a macro should open the link provided in chrome and when the page loads, it should copy the link page after loading and paste in the next column .

eg.
https://support.hp.com/in-en/search?...38Z00X&filter=

if you open the above link it will redirect to the below link

https://support.hp.com/in-en/product...57?sku=2MB48PA

I have link in column "A" and require the final link in column "B".

Thanks, any help would be appreciated.

Originally Posted by Sean Thomas

Never done anything with Chrome, but I found this - maybe the reason why not much about it

Google Chrome does not provide a Visual Basic interface like Internet Explorer does, so you cannot access any of it's properties (e.g. Document). You can launch chrome at a specific address just by passing to the executable.

For example:

Please Login or Register  to view this content.

Apparently there's an excellent resource library called Selenium that has VBA Wrappers

http://www.makeuseof.com/tag/how-to-...-and-selenium/

Thanks Sean,
I would appreciate if you could help me copy the url in excel. Using IE if possible, Kindly help with the code for same.
opening multiple browser would cost memory, it could be reduced by opening a browser once and next open the link in new tab to save memory.

Help me how can I fetch the link back in excel sheet.

Originally Posted by MarvinP

Hi Sunny,

Using Excel, I expect you can open a hyperlink to the default browser. I'm not sure you can specify which browser will fire, if you have multiple browsers installed on your computer. Then the control of the OS is in the browser and you would need to copy the URL from the browser window and copy it into the windows Copy buffer and then go back to Excel and Paste the URL into the same row using the B column.

I simply don't know how to do the above process. The whole time you are using Excel VBA. I do know that while in Excel you can use "DoEvents" which will allow the OS to do other things before it comes back to Excel and this might be part of your problem. I don't use Chrome (I'm an Edge guy) and can't even try it.

Sorry - perhaps this answer will bump this thread and another user will have an answer for you.

Thanks for your response,
I would also not prefer chrome browser but if possible with IE then I don't have any issue , I fail to copy back the link in excel.

Originally Posted by Sean Thomas

Every time I try that site it shows an error - possibly site is down for some reason.
What have you tried so far?

Hi Sean,
The link is down, But there are other links in the file.
you may try this one

https://support.hp.com/in-en/search?...38Z02N&filter=
the result link is
https://support.hp.com/in-en/product...57?sku=2MB48PA

The other cause may be because of the country.
If the above link doe not works follow the below process:
1.Open the link below
https://support.hp.com/in-en/products
2.Enter the product number INA738Z02N in the search box and hit Find.
Capture.PNG
3.Now the final link is required in the sheet.

Originally Posted by Sean Thomas

this will get you started.
However some of the websites cause a few issues loading

Please Login or Register  to view this content.

Thanks a lot, this has been so helpful to me.
If any more modification is required will approach you.

Hello,

This is doing well but consuming lot of memory, could you check weather the IE is already open or not.
If already open, can we search the link by opening the link in new tab and then close the tab.
Instead of opening a new browser and closing it every time.

Thanks You.