I tried this but the MSN commands don't show up in the Commands list.
Thanks

"Bill Martin" wrote:

John F wrote:
I'm using VB 6 with Win XP Pro and Office 2002. I have a spreadsheet with msn
stock quotes that updates successfully using the keyboard (alt+u) or the
mouse (click on update quotes).

However, sending the same keys using sendkeys from VB 6 produces the "#Name"
error in Excel, with no prices updated.

Any ideas on how to use sendkeys to accomplish the quote update? Or another
method?

Thanks


If you right click on the button and follow your nose through the menus a bit
you can see the name of the macro assigned to that button. Then from your macro
you're writing you can just directly call that macro by name rather than
screwing around with the button.

Bill