Hi,
I want to use macro to open a website which is stored as hyperlink in my sheet e.g. in A1. I have been using a macro, which had a direct link in its code, but now
want the macro to take the link that is in a given cell e.g. from A4.
What do I need to put after the "GET", before False at the end?
Thank you![]()
With CreateObject("msxml2.xmlhttp") .Open "GET", "Webpage address from a cell in the sheet e.g. Sheet 1, A1", False .Send oDom.body.innerHtml = .responseText End With
Bookmarks