Automatically import information from webpage into Excel Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Just wondering if information can be automatically drawn from a web page and
put into a cell....where each day I can open up the Excel spreadsheet...click
a feature that does a refresh function and all the cells will be updated

eg, the price for BHP shares on the ASX

http://www.asx.com.au/asx/markets/PriceResults.jsp?method=get&template=F1001&ASXCodes=bhp

can the "Last" price be automatically entered into a cell?

I am assuming that if it can, it would be difficult, but once completed, can
be replicated for a whole number of cells etc
 
When on the web page place cursor on the table desired>right click>import to
microsoft excel. Post back if you have more questions.
 
Hi Don,

Thanks for the heads up....but doing that brings in the whole table...I am
only looking for the "last price" cell of the web page table to be
automatically updated into Excel cell

I have tried the Data/Import External Data/New Web Query function...but I
can't seem to stipulate that particular piece of information

Any further assistance would be appreciated
 
Import to a "source" sheet and then have your macro extract to the desired
sheet. You can have it copy to the same or a row lower to archive your
results.
 
Back
Top