Macro to Update Stock Quotes - Tech Support Guy Forums

Search
Search for:

>
Macro to Update Stock Quotes

Thread Tools

tpdjr

Junior Member with 1 posts.

Join Date: May 2009

Experience: Intermediate

21-May-2009, 02:29 PM #1

Macro to Update Stock Quotes

Hi--
I have an Excel 2007 spreadsheet that uses the MSNMoney Stock Quotes add-in to retrieve the latest prices for a list of stocks. However, in order to get the latest prices I have to open the add-in and hit the "Update Quotes" button.

I'd like to simply put a command button on the spreadsheet that would automatically execute the Update Quotes command when clicked.

I tried to record a macro to do this but it did not work. Is there a way to do this using Visual Basic instead? Many thanks!

techguy.org/828938

Tags

excel, macros, update quotes

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

« Previous Thread | Business Applications | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.

Thread Tools
Show Printable Version Email this Page

Tag Cloud
access acer asus bios bsod computer crash desktop dns driver drivers error ethernet excel freeze gaming graphics hard drive hardware hdmi internet laptop malware memory monitor motherboard network printer problem ram registry repair router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!