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=f ormLoader&formL oader.targetFor mId=AD01"

Protocol - "HyperText Transfer Protocol with Privacy"

Type - "UK//RUNPAGE File"

Address (URL) - "https://ewf.companiesho use.gov.uk//runpage?page=fo rmLoader&formLo ader.targetForm Id=AD01"

Viewing the Source Code shows:

<a href="http://bytes.com/runpage?page=fo rmLoader&formLo ader.targetForm Id=AD01"class=" addressLink smallFont">Chan ge 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.