How do I pull data from a website to populate into Excel

[cojeda]

I need to automate a manual reporting process that is completed everyday by one of my colleagues. They manually populate an Excel report by typing data off of various websites (for example,

http://www.wsj.com).

Essentially these are common financial market indexes that are compiled for executive management to have a quick lay of the land with regard to the economy. What are my options and how hard would this be. Your help would be very appreciated!

Thank You!

C.

 

[SkipVought]

Hi,

Check out Data > Import External Data > New Web Query

In this wizard, navigate to the site, select the date of interest and import.

Once established, you need only Data > Refresh to retrieve new data.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[gearhead03]

Is there anyway to make the query use a cell value to retrieve a page?

Example:

http://www.safersys.org/query.asp?s...aram=MC_MX&query_string=460652&Go.x=13&Go.y=8

Where "460652" would change based on the value entered in a cell.


Mark A. Kale

 

[SkipVought]

Only with a macro AFAIK.

Post in Forum707.

Include the code you generate from turning on your macro recorder and recording doing the following...

Data > Import Data > Edit

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]