+ Reply to Thread
Results 1 to 3 of 3

Macro - Download the data from website (require several submit)

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    34

    Macro - Download the data from website (require several submit)

    Dear Professionals

    I have been using the following macro script to download data from a website to a newly create Excel file named "seed"

    It works well for months but suddenly fail today. Can you assist to fix the bug please? Many thanks in advance

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Macro - Download the data from website (require several submit)

    You're going to need to give us the site url and some test data to be able to help you

  3. #3
    Registered User
    Join Date
    07-29-2014
    Location
    Hong Kong
    MS-Off Ver
    2010
    Posts
    34

    Re: Macro - Download the data from website (require several submit)

    Dear Kyle

    Web: http://webb-site.com/

    step 1: enter the stock code
    step 2: press "current"
    (Next page)
    step 3: Press "Raw Prices"
    (Next page)

    at this page, what i need is to capture the whole table (price data) and put into a newly created Excel named "Seed"

    the above code can work previously, but now... when i run the macro, the result is creating a new excel file "seed" with blank content...

    I have attached an excel file, which is the expected result... thanks in advance
    Attached Files Attached Files
    Last edited by tatfish87; 06-03-2015 at 12:19 AM.

+ 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 download data from website (need fill in info and redirect to further pages)
    By tatfish87 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 11-30-2014, 10:30 PM
  2. Creating a macro to download data from a secure website
    By bakerbaz04 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2014, 01:38 PM
  3. Submit options from dropdown menu and get data from website
    By zahoor1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2014, 06:31 AM
  4. [SOLVED] Macro to submit results in website and copy to excel template
    By dobracik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2013, 03:17 PM
  5. Creating macro that will submit email address on a website
    By thomasmale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2009, 10:10 AM

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