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
Bookmarks