Auto add URL and Macro button

Hi,
I would like to create a Macro to automatically create a URL and a button to run a Macro that opens the URL when clicking the button.

Code URL
AAPL http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=snd1
GOOG http://finance.yahoo.com/d/quotes.csv?s=GOOG&f=snd1
xxxx http://finance.yahoo.com/d/quotes.csv?s=xxxx&f=snd1

(The URLs are assigned to the code respectively and open the URL when clicking on the code)

How do I create the Macro to do all: assigning URL, creating button, opening URL when clicking? Please help.
Thanks in advance.

Hi tywlam,

See the attached file which includes the following Macros. This should help you get started. Please feel free to ask if you have additional problems or questions.

In an ordinary code module such as Module1:

Please Login or Register  to view this content.

FYI (For Your Information):
It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

Great. Thanks, Lewis.

One more: How do I modify the code to include a URL: "http://finance.yahoo.com/q?s=" & sStockSymbol & "&ql=1" to open the URL in a browser when clicking the stock symbol?

Assign this macro to a shape and launch to open the URL in a browser,

Please Login or Register  to view this content.

See how it works for you.

//berlan

Originally Posted by tywlam

How do I modify the code to include a URL: "http://finance.yahoo.com/q?s=" & sStockSymbol & "&ql=1" to open the URL in a browser?

See the attached file which includes the following Macros. There are 3 options in the file:
a. Create a shape that gets the latest stock price when clicked.
b. Create a shape that opens the Yahoo Finance URL that gets stock summary information. This is done by assigning a Hyperlink to the shape.
c. Create two half size shapes. The Left Shape gets the latest stock price. The Right Shape opens the URL.

In an ordinary code module such as Module1:

Please Login or Register  to view this content.

Lewis

Hi Lewis,

Thanks a lot for providing the three options. They are very helpful.
Same issue on opening the URL: What change should be made in your VBA in order to open the url in Firefox instead of the default IE?

Regards,
Terry

I think I got it.
Thks