Need VBA to click link on website and open new form without logging out

[Ochimus]

I have written an Excel Macro that opens a website, adds data to textboxes, and "clicks" to next page.

This new page has a "link" that opens a new Form when clicked,

I tried to Code the "click" to open the new Form automatically, but get a message that "If you leave this page, you will lose your session and be logged out".

Right-clicking the phrase shows the following Properties:

General - "runpage?page=formLoader&formLoader.targetFormId=A D01"

Protocol - "HyperText Transfer Protocol with Privacy"

Type - "UK//RUNPAGE File"

Address (URL) - "https://ewf.companieshouse.gov.uk//runpage?page=formLoader&formLoader.targetFormId=AD 01"

Viewing the Source Code shows:

<a href="http://bytes.com/runpage?page=formLoader&formLoader.targetFormId=AD 01"class="addressLink smallFont">Change address</a> </div> <div class="grid_4">

Hope this can enable someone to explain how to "code" the link?

[Rabbit]

It sounds like the logging out and destruction of the session is part of the coding of the site. There's nothing you can do about that.

Unless you're saying that if you do it manually it doesn't log you out. In which case, there's hidden form data that you need to submit. Or you need to simulate the actual clicking of the link instead of just inputting the url. Either method should work.