msmith
09-13-2005, 09:33 PM
Hey all-
I am using the MSN stock Quote Add-in from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=EN
I'm not sure if this is a good one to use but will take any suggestions at this point.
Ultimately, what I would like to do is run a macro that that will track stock prices in a portfolio over a period of time. I have enough knowledge to get the code for adding in new data to a certain cell range to track changes over time. I don't know how to call the Add-in feature that updates the stock quotes. Is this even possbile within a macro? I don't have knowledge on how to call add-ins. The update works if I just hit the button but then I have to do manual copy and paste(s) to get the data where I want. I would like to automate this.
Thanks in advance,
Mark
I am using the MSN stock Quote Add-in from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=EN
I'm not sure if this is a good one to use but will take any suggestions at this point.
Ultimately, what I would like to do is run a macro that that will track stock prices in a portfolio over a period of time. I have enough knowledge to get the code for adding in new data to a certain cell range to track changes over time. I don't know how to call the Add-in feature that updates the stock quotes. Is this even possbile within a macro? I don't have knowledge on how to call add-ins. The update works if I just hit the button but then I have to do manual copy and paste(s) to get the data where I want. I would like to automate this.
Thanks in advance,
Mark