Thread: how do I update stock quotes using automation with vb
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John F[_2_] John F[_2_] is offline
external usenet poster
  
Posts: 24
Default how do I update stock quotes using automation with vb
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

Reply With QuoteReply With Quote