Executing Excel menu commands from VB

[Ed White]

Is there a way to execute Excel commands not otherwise available in VB or VBA
other than using SendKeys? For example, I am using the MSN Stock Quotes
Add-In, and I cannot find a VBA command to do Data-->Stock Quotes from MSN
Money-->Update Quotes. I seem to recall that Access has a cmd command that
allows you to execute any menu command sequence on the Access menu, but I
can't find a similar command in Excel. Is one available?

 

[Peter Huang [MSFT]]

Hi

I assume you means the addin.
Excel 2003/2002 Add-in: MSN Money Stock Quotes
http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-
B939-3BF0A740A9B1&displaylang=EN#Overview

I think you may try to record a macro to see if there is any code
corresponding to your code.
Because we manipulate the Excel by using Excel Object Modal, but the
Addin's menu or button commonly is not included in the Object Modal.

Also for this Free Download Addin, based on my research, there are no
documents.

If you still have any concern, please feel free to post here.

Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Ed White]

Yes, that is the addin I was referring to. I did try turning on the macro
recorder in VBA and typing in those commands for the addin, but nothing was
recorded in the macro recorder.

Back to my original question, is there a way to send commands to Excel to
execute commands on the main menu similiar to the cmd command for Access?

 

[Peter Huang [MSFT]]

Hi

I am not familar with Access. But I have browsed throught all the Excel
Object Modal, it did not provide such a CMD object to execute.
As I said before we automation Excel(send commands to Excel) via Excel's
Object Modal.

BTW: Commonly for free download software, we did not provide support.

If you still have any concern, please feel free to post here.

Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.