I need a quote to come from the net into say cell "D4" in excel
The next time it refreshes, I want that current quote "snapshoted"
and placed directly underneath into "D5".
and cell "D4" becomes the new current quote just brought in from the
net.

and for the day it'll do this every minute.

buy the end of the day I should have a list that looks like below.

$3.00
$3.00
$3.10
$3.00
$3.10
$3.50
$3.40
$3.20
etc all the way down.

Totally apprieciate the help! thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Leaving the import and timer part of the macro out ( I assume you already
have this)

prior to updating cell D4
add code

range ("D4").select
selection.insert shift:=xlshiftdown

then carry out your refresh of data

Steve

"0o0o0" wrote in message
...
I need a quote to come from the net into say cell "D4" in excel
The next time it refreshes, I want that current quote "snapshoted"
and placed directly underneath into "D5".
and cell "D4" becomes the new current quote just brought in from the
net.

and for the day it'll do this every minute.

buy the end of the day I should have a list that looks like below.

$3.00
$3.00
$3.10
$3.00
$3.10
$3.50
$3.40
$3.20
etc all the way down.

Totally apprieciate the help! thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Im currently studying a VBA code book and youve presented me with macro
stuff, this is all coming together now!

Although 'no' I havent done an import and timer thing.. or have I?
lol.. would this be in the iqy file?

if not can you add this to the last string you sent me?

Thanks for the help!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/