Results 1 to 1 of 1

How to write a macro to download a webpage table in MS Excel every hour

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    1

    Cool How to write a macro to download a webpage table in MS Excel every hour

    Hi everyone,

    I need to download a webpage table every hour for subsequent analysis. The idea is to get a snapshot of the table every hour and save it as a different tab. In a day, I would have 1 excel file with 24 tabs (for each hour)

    Is there a way to automate the hourly download? The computer it will run on is open 24 hours and has access to the internet.

    I attached a sample file for reference. Would really appreciate your help on this.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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