Closed Thread
Results 1 to 5 of 5

Get data from website

Hybrid View

adamgrier Get data from website 09-16-2009, 08:35 PM
teylyn Re: Get data from website 09-16-2009, 08:50 PM
adamgrier Re: Get data from website 09-20-2009, 10:26 PM
veejar Re: Get data from website 05-28-2012, 12:40 PM
arlu1201 Re: Get data from website 05-28-2012, 01:17 PM
  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    23

    Get data from website

    I am working on a problem where I have a list of about 200 titles that I need to enter into a website and then copy and paste the results that are displayed. The good news is the results are in a consistent format.

    Is there any way to record a macro to do this.

    Ideally, I would like to record a macro in such a way that it understands each of the steps required to collect all of the data, then let it work its way down the list of 200 data points.

    What do you think.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Get data from website

    Do you mean you want Excel to copy data from cells to the web and then copy and paste something back from the web? If so, I doubt that you'll be able to do that, not even with VBA.

  3. #3
    Registered User
    Join Date
    08-18-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    23

    Re: Get data from website

    No i want excel to select a piece of data to input into a websearch from a list provided in excel. Then copy and paste the results that the websearch produces.

  4. #4
    Forum Contributor
    Join Date
    05-14-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    187

    Re: Get data from website

    Has anyone got an answer to this thread

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Get data from website

    Veejar,

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed 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