Automatically import information from webpage into Excel Cell
 

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/Pr...ASXCode s=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

Automatically import information from webpage into Excel Cell
 

When on the web page place cursor on the table desiredright clickimport to
microsoft excel. Post back if you have more questions.


--
Don Guillett
SalesAid Software

"Spesh" wrote in message
...
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/Pr...ASXCode s=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

Automatically import information from webpage into Excel Cell
 

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

"Don Guillett" wrote:

When on the web page place cursor on the table desiredright clickimport to
microsoft excel. Post back if you have more questions.


--
Don Guillett
SalesAid Software

"Spesh" wrote in message
...
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/Pr...ASXCode s=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

Automatically import information from webpage into Excel Cell
 

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.
--
Don Guillett
SalesAid Software

"Spesh" wrote in message
...
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

"Don Guillett" wrote:

When on the web page place cursor on the table desiredright clickimport
to
microsoft excel. Post back if you have more questions.


--
Don Guillett
SalesAid Software

"Spesh" wrote in message
...
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/Pr...ASXCode s=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