Posted to microsoft.public.excel.programming

John F[_2_] John F[_2_] is offline

external usenet poster

Posts: 24

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Stock Quotes #VALUE for some entires on update	Mark Taylor	Excel Discussion (Misc queries)	1	March 11th 08 07:12 PM
MSN Stock Quotes Addin fails to update	[email protected]	Excel Worksheet Functions	1	February 14th 08 01:02 PM
How do i get historical stock quotes using MSN Money Stock Quotes	Ash	Excel Discussion (Misc queries)	0	May 11th 06 03:26 AM
Stock quotes	Craig	Excel Discussion (Misc queries)	3	April 30th 05 11:11 PM
DDE link update for stock quotes	[email protected]	Excel Programming	0	August 27th 03 04:13 PM

All times are GMT +1. The time now is 07:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us