Automating data exctract from a data website.

Hi everyone,

So here's the deal. I have data that is stored in a website. This website is basically a warehouse of metrics, displaying them in pivot table format, and they are able to be exporting using excel. Everyday I need to access a certain page of this website and extract data to an excel file. Is there any way I can automate this process? Thanks.

Originally Posted by 6StringJazzer

It depends on how the web site presents the data. If the data is coded as a table, then you can set up an Excel web query (see Excel Help or google it). It can be refreshed by two clicks. To further automate, you can have VBA code (macros) that automatically refresh the data from the web site.

Another more complex option is VBA that parses the HTML for the page to extract data and load it in a spreadsheet.

The data IS coded as a table. This helps me out a lot. What I'm looking for is a macro to extract the data and bring it into the excel sheet, automatically.

Look up "web query". I can provide specifics and even set it up if you provide the URL.

Thanks for the offer, but i'm going to figure this out on my own. You have been very helpful.