I am able to load a cell in an Excel spreadsheet with something like

=MSNStockQuote("msft","Last Price","US")

However, I would like to load a variable in a VBA module with something like:

curPrice = MSNStockQuote("msft","Last Price","US")

butI get “Variable Not Defined” even though curPrice is defined.

I also tried unsuccessfully with:
curPrice = MSNStockQuote.Functions.MSNStockQuote("msft", "Last Price", "US")

How do I call the MSNStockQuote function from within a VBA module. ?

And is it possible to use this call to return more than one parameter at a time,. Say I wanted Price and time of day as well. Can I do this with a single Function call?

Thanks,

Gary

When I enter what you have here verbatim, I get the familiar #NAME?

How do you have this MSNStockQuote? Is it a library that you have added to your Excel project? Or . . . ?

Yes, MSNStockQuote is a Microsoft PlugIn for Excel 2003. You can download it at
http://www.microsoft.com/downloads/d...DisplayLang=en

Gary

this works for me (after installing and then adding the reference in Tools | references of course)....

Sub Test()
    Dim x As New MSNStockQuote.Functions
    y = x.MSNStockQuote("URBN", "Last", "US")
End Sub