# Revision history [back]

Hello,

Have attached a working sample based upon you question link.

When you open the sample you will get a message stating the link is disabled. Enable with the button provided.

Cell A1 is the Rank & A2 is the week. Enter what you want & press the Retrieve Data button.

When creating/modifying external links care is needed. You create once & modify after. The links are stored by index for the document so you need to know the index of the link to be modified. In the macro, the insert statement for the link is commented out and the link thereafter just needs the URL changed. In this sample there is only the one link.

Comments are provided in the macro for clarity.

Hello,

Have attached a working sample based upon you question link.

Cell A1 is the Rank & A2 is the week. Enter what you want & press the Retrieve Data button.
When creating/modifying external links care is needed. You create once & modify after. The links are stored by index for the document so you need to know the index of the link to be modified. In the macro, the insert statement for the link is commented out and the link thereafter just needs the URL changed. In this sample there is only the one link.