Form what source?
If you have a realtime trading platform, most have excel a DDE links
available.
Although, depending on what platform you use and your permission level, you
may not get dividend Exdate and Paydate. Probably need Reuters or a Bloomberg
terminal for that.


Rick wrote:
I looked at all your variations, but I need only a simple stock quote return.
Giving sysmbol, long name, date, time, current price, last open last close.
Xdiv and date if it is given. I am not a experienced vba coder, just self
learning.

--
Message posted via http://www.officekb.com