Hi there,

I have some text on a webpage that I want to copy and paste into an excel document.

Problem is there are 704 pages, so I dont want to go through each one pressing next etc and then copying and pasting the text out of them.

The url format follows page=1, page=2...page=704

i.e. www.website.com/page=1

This means that I can type any page number URL and it will load up that page.

How would I automate the following process:

1. Load URL Page 1
2. Copy text
3. Paste to Excel
4. Load URL Page 2
5. Copy text
6. Paste to excel
7. repeat till page 704 etc

Thanks for your help