07 Ribbon Macros

[BruceA]

OK,
So I designed my new ribbon the way I want it, and have all of the macros
written for everything in the DBase. The problem I am now having is that I
would like to open an external WORD file from the Ribbon, but can't seem to
get the code quite right. Can someone guide me through this process? If the
macro can be typed directly into the xml, or if I have to call a separate
vba, please advise and how....
thanx to everyone for help.

 

[Steve Schapel]

Bruce,

If you are calling a macro from the OnAction property of the ribbon
button, then the Action to use in the macro is the RunApp action. The
Command Line argument in the macro will look something like this:
"C:\Program Files\Microsoft Office\...\Winword.exe"
"C:\YourFolder\YourFile.docx"

 

[brucea]

Bruce,

If you are calling a macro from the OnAction property of the ribbon
button, then the Action to use in the macro is the RunApp action.  The
Command Line argument in the macro will look something like this:
"C:\Program Files\Microsoft Office\...\Winword.exe"
"C:\YourFolder\YourFile.docx"

--
Steve Schapel, Microsoft Access MVP




- Show quoted text -

So what does the entry look like in the xml line? Ive tried different
variations of this: onAction=RunApp "C:\Program Files
\Office12\winword.exe""C:\My Documents\My Filename and exension"

What's missing and where?
Thanks Steve

 

[Steve Schapel]

Bruce,

I don't know how to write this directly into the ribbon xml. I was
talking about making a Macro using the RunApp action. And then writing
the macro name into the ribbon xml.

As regards "what's missing", for one thing a space between the 2
sections of the Command Line:
"C:\Program Files\Office12\winword.exe" "C:\My Documents\My Filename and
exension"