MSN Stock Quote Update

  • Thread starter Thread starter Gregg G
  • Start date Start date
G

Gregg G

I need to write a macro that will, upon opening a
specific Excel file, automatically update the current
stock quotes using the MSN Money Stock Quote add-in, then
e-mail the file to my e-mail address (let's say
(e-mail address removed)), and then close the file and exit Excel.
Since I'm not much good at macro programming, and the
recorder isn't much help here, I could use some help.
Thanks in advance.

Gregg
 
While I don't know anything about the add-in you reference, why is the
macro recorder not of any help? Maybe, if you use the recorder to do
all that you can, someone will help fill in the gaps. ;-)

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
I think I remember how to set up a macro to auto-run when
the file is opened, but the recorder doesn't work for the
other functions (close a file, exit Excel, send file as an
attachment, and access the MSN Money Quote Add-in). Some
of these I could look up on my own, but I figured that as
long as I needed help on the e-mail and the add-in, the
rest is probably very basic to someone who does this all
the time. The MSN Money Add-in is available through the
Microsoft Office website. Is there at least a semi-
standard method of accessing add-ins?
-----Original Message-----
While I don't know anything about the add-in you reference, why is the
macro recorder not of any help? Maybe, if you use the recorder to do
all that you can, someone will help fill in the gaps. ;-)

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
Click to expand...
 
If all else fails, you can use SendKeys to emulate pressing the necessary keys to refresh the
quotes. The other option would be to see if you can figure out what macro is called by clicking
on the appropriate MSN menu option, then calling that routine from your macro.


I think I remember how to set up a macro to auto-run when
the file is opened, but the recorder doesn't work for the
other functions (close a file, exit Excel, send file as an
attachment, and access the MSN Money Quote Add-in). Some
of these I could look up on my own, but I figured that as
long as I needed help on the e-mail and the add-in, the
rest is probably very basic to someone who does this all
the time. The MSN Money Add-in is available through the
Microsoft Office website. Is there at least a semi-
standard method of accessing add-ins?
Click to expand...
 
Back
Top