+ Reply to Thread
Results 1 to 4 of 4

Macro to copy data from website and paste into excel

  1. #1
    Registered User
    Join Date
    02-14-2015
    Location
    United States
    MS-Off Ver
    OS X Office 2001
    Posts
    2

    Macro to copy data from website and paste into excel

    Hello,

    I am looking for a Macro that will copy information from a website that I will specify and paste it into my excel file. I would also need this to run every 15min on its own once I start it in the morning and let it go automatically throughout the day until the file is closed. I do not have any VBA knowledge so I would not know where to start. Does anyone know what I can do to make this happen?

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Macro to copy data from website and paste into excel

    I may be able to help out on the first part (copy information from website). However I will need to know a) the websites URL and b) what information you want to scrape.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  3. #3
    Registered User
    Join Date
    05-14-2015
    Location
    Atlanta GA
    MS-Off Ver
    2007
    Posts
    16

    Re: Macro to copy data from website and paste into excel

    Could you help me? I need to get the mileage, make, year and link to the actual listing on http://www.ebay.com/sch/Motorcycles-..._skc=200&rt=nc. Thanks!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Macro to copy data from website and paste into excel

    gautum123, unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy data from website and paste to Excel
    By RedLeaderX in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2015, 03:52 PM
  2. Excel Macro to copy paste ecel data to website
    By muthu_1289 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 11:32 AM
  3. copy and paste data from website to excel
    By aishaz_88 in forum Excel General
    Replies: 2
    Last Post: 12-02-2007, 09:52 PM
  4. Macro to Copy data from e-mail and paste it into a field on a website
    By joebobcletusjr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 01:19 PM
  5. Replies: 0
    Last Post: 02-14-2005, 02:09 PM

Tags for this Thread

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