Macro to click on a dynamically generated hyperlink

Hi all... total newbie to this here with only the knowledge that google and working backwards on existing macros has given me....

So i'm trying to write an excel macro that will navigate to a webpage, enter some details from a worksheet, save them and then click on a dynamically generated hyperlink that is produced from the entered information. This link changes dependant on what information is entered.

I can navigate to the page, enter the details, save but i'm unable to get the macro to click on the link generated due to it always being different. I've tried a number of solutions I have come across, but nothing seems to work.

The relevant parts of the code are as follows:

Please Login or Register  to view this content.

Any ideas?

Is there anything in the URL of the link you could use to identify it?

If there is you could get the collection of all the links on the page using appIE.document.links, loop through it, identify the link you want and then click it.

PS Can you please add code tags when posting code?

Is there anything in the link that could be used to distinguish it from the other links on the page?

For example is the 'mUserProfile.aspx' part of the link unique to the link?

If it was you could use something like this.

Please Login or Register  to view this content.