+ Reply to Thread
Results 1 to 2 of 2

Automated copying of text from webpages to excel

  1. #1
    Registered User
    Join Date
    10-27-2005
    Posts
    14

    Automated copying of text from webpages to excel

    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

  2. #2
    Registered User
    Join Date
    10-14-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Automated copying of text from webpages to excel

    Have you considered the Sendkeys Option?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1