Getting data from web page
 

I am trying to do something very similar to the user in this post:

http://groups.google.com/group/micro...c00a6ae619610a

I copied the code from Jake Marx on the bottom of the page and am able
to run it w/o any errors but no data appears in my spreadsheet. I
guess the "Debug.Print" isn't working. I have looked at the source URL
and can't see any reason why the data wouldn't be returned.

Can someone tell me what I'm doing wrong?

Thanks!

Getting data from web page
 

Hi Scott

The data is in variables at the conclusion of Jake's example.
Debug.print puts something in the "Immediate" pane in the VBA editor.
If you want it on your spreadsheet too, you can add some lines such as:

Debug.Print msDIVIDEND_RATE & ": " & Mid$(s, nStart, nEnd - nStart) '
existing line from JMs code
ActiveCell.Value = msDIVIDEND_RATE & ": " & Mid$(s, nStart, nEnd -
nStart) ' puts the same thing in the active cell
activecell.offset(1,0).activate ' move to an empty cell to put the
next piece of data into



Kevin

Getting data from web page
 

Kevin,

Thanks for the quick reply. I am new to this and was unfamiliar with
the Immediate pane and debug output. I figured that much out shortly
after posting but still didn't know how to get the data into a cell.

Thanks again!

Scott