Need to know how to obtain this...please

  • Thread starter Thread starter 0o0o0
  • Start date Start date
0

0o0o0

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.
 
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
 
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!
 
Back
Top