Results 1 to 6 of 6

Look for text in a webpage then copy/paste to excel

Threaded View

dogankurban Look for text in a webpage... 11-24-2013, 10:05 PM
Marc L Re: Look for text in a... 11-24-2013, 11:01 PM
dogankurban Re: Look for text in a... 11-25-2013, 03:19 AM
nilem Re: Look for text in a... 11-25-2013, 04:34 AM
Marc L See the Demo procedure : 11-25-2013, 07:58 AM
dogankurban Re: Look for text in a... 11-25-2013, 11:56 AM
  1. #1
    Registered User
    Join Date
    03-16-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    6

    Look for text in a webpage then copy/paste to excel

    Hello,

    I am trying to do below with an excel macro but got stuck, can anyone help please? I have been digging up the internet for hours now but could not find anything close to it.

    - Open a web page (I can do this bit )
    - Within the web page, find the first piece of text that starts with # symbol.
    - Copy the 7 digits right after the # symbol, and paste to excel.

    The page always has a # and 7 digit number, always close to top of the page. (example: #3245454 ; I need the 3245454 to be written to a cell in excel)

    Best Regards and thanks a lot for your help!
    Last edited by dogankurban; 11-24-2013 at 10:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to paste code from webpage into excel
    By Priya24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2012, 10:48 AM
  2. Copy Paste from Excel to Webpage
    By Manshah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2012, 06:24 AM
  3. Replies: 3
    Last Post: 07-29-2012, 05:05 PM
  4. macro that will go to a specific webpage,copy and paste
    By Billy Dee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2010, 11:49 AM
  5. Copy & Paste from Webpage with IE
    By Mike Hogan in forum Excel General
    Replies: 2
    Last Post: 04-22-2006, 02:15 PM

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