S
Scott
I am using MS Office 2003 and I have a spreadsheet set up in excel to manage
my stocks. I use the MSN StockQuoter add in. While excel is great for
crunching numbers, it is becoming a bit cumbersome trying to keep my stock
history in order.
I have built an access DB that holds all of my stock information, and I use
queries to generate my charts. This is much more efficient for me than trying
to keep up with it all over several spreadsheets. I have tried to no avail to
program access to use the functions of the stockquoter library through an
excel workbook object as well as directly from access to automatically update
my quotes and add them to a table of each days quotes. I have set a reference
to the add in's 'type library', and can view the object's functions
collection in the "object viewer" window which exposes the following function:
MSNStockQuote.Functions.MSNStockQuote(Symbol As String, [Property As _
String = "Last"],
[CountryCode As String = "US"])
The line I am using is this
curCurrentQuote = MSNStockQuote.functions.MSNStockQuote ("FCNTX")
the variable curCurrentQuote is declared as currency
Unfortunately, when I try to run the code, the compiler won't even accept
the code syntax saying the the method or data member not found refering to
the "functions" member. I also get the same message if I try to run the same
line directly in Excel VBA.
Is there something I am missing? or is this not even possible?
my stocks. I use the MSN StockQuoter add in. While excel is great for
crunching numbers, it is becoming a bit cumbersome trying to keep my stock
history in order.
I have built an access DB that holds all of my stock information, and I use
queries to generate my charts. This is much more efficient for me than trying
to keep up with it all over several spreadsheets. I have tried to no avail to
program access to use the functions of the stockquoter library through an
excel workbook object as well as directly from access to automatically update
my quotes and add them to a table of each days quotes. I have set a reference
to the add in's 'type library', and can view the object's functions
collection in the "object viewer" window which exposes the following function:
MSNStockQuote.Functions.MSNStockQuote(Symbol As String, [Property As _
String = "Last"],
[CountryCode As String = "US"])
The line I am using is this
curCurrentQuote = MSNStockQuote.functions.MSNStockQuote ("FCNTX")
the variable curCurrentQuote is declared as currency
Unfortunately, when I try to run the code, the compiler won't even accept
the code syntax saying the the method or data member not found refering to
the "functions" member. I also get the same message if I try to run the same
line directly in Excel VBA.
Is there something I am missing? or is this not even possible?