Help with .Open "GET" code

[jakg88]

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?

Please Login or Register  to view this content.

Thank you

[Leith Ross]

Hello jakg88,

You need to supply the URL as a string. Be sure it is fully qualified with the proper protocol string: http://, ftp://, etc. This won't be a problem when retrieving the URL from a hyperlink.

This macro will retrieve a hyperlink either from a formula, VBA, or manually added hyperlink. Add a new module to your workbook and paste the macro into.

Get URL from Hyperlink Formula or Range object

Please Login or Register  to view this content.

Using the macro in Your Code

Please Login or Register  to view this content.

[jakg88]

Hi,

Thank you so much for your help.

I pasted the function and modified my code, but it seems like it doesn't like this part:

Please Login or Register  to view this content.

as it returns error.

Any idea where I went wrong?

Thank you

[Leith Ross]

Hello jakg88,

Can you post a copy of the workbook for me to review?

[jakg88]

Managed to get it work. Thank you very much for all your help!

[Leith Ross]

Hello jakg88,

What was the fix?

[jakg88]

Your code was all spot on. Was just me doing some typo. Tried it again in a new file and worked brilliantly. Thank you again