Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How can I run macro inside ppa file from VBA?

64 views
Skip to first unread message

sujatha....@gmail.com

unread,
Jan 14, 2008, 4:24:13 PM1/14/08
to
Hello,

I have written few macros in a ppt file. It is accessible via the
Tools->Macro menu.
I have created an Add-In by saving ppt file as a ppa. I am creating a
toolbar, with pull down menu, each menu option is a macro.
I can then open any ppt file, load add-in via Tools->Add-ins, and the
toolbar works fine. or I can do auto-load by adding the .ppa to the
registry.
My question is, Is there a way to programatically run the macro from vc
++? an example in vb would be helpful as well. I tried
Application.Run(ppaName!ModuleName.MacroName), but it doesn't seem to
be working.

Thankyou.

Shyam Pillai

unread,
Jan 14, 2008, 9:22:28 PM1/14/08
to
Application.Run is the way to fire the macro. It works if the reference to
the application and rest of the arguments are correct.

Regards,
Shyam Pillai

Image Importer Wizard
http://skp.mvps.org

<sujatha....@gmail.com> wrote in message
news:823dc118-26b8-4a83...@d4g2000prg.googlegroups.com...

sujatha....@gmail.com

unread,
Jan 15, 2008, 10:47:36 AM1/15/08
to
On Jan 14, 7:22 pm, "Shyam Pillai" <ShyamPil...@Gmail.com> wrote:
> Application.Run is the way to fire the macro. It works if the reference to
> the application and rest of the arguments are correct.
>
> Regards,
> Shyam Pillai
>
> Image Importer Wizardhttp://skp.mvps.org
>
> <sujatha.kokkir...@gmail.com> wrote in message

>
> news:823dc118-26b8-4a83...@d4g2000prg.googlegroups.com...
>
>
>
> > Hello,
>
> > I have written few macros in a ppt file.  It is accessible via the
> > Tools->Macro menu.
> > I have created an Add-In by saving ppt file as a ppa. I am creating a
> > toolbar, with pull down menu, each menu option is a macro.
> > I can then open any ppt file, load add-in via Tools->Add-ins, and the
> > toolbar works fine. or I can do auto-load by adding the .ppa to the
> > registry.
> > My question is, Is there a way to programatically run the macro from vc
> > ++? an example in vb would be helpful as well. I tried
> > Application.Run(ppaName!ModuleName.MacroName), but it doesn't seem to
> > be working.
>
> > Thankyou.- Hide quoted text -
>
> - Show quoted text -

Thanks for your response.
I have tried Application.Run, but it doesn't work. When I am in the
ppt file, Tools->Add-in shows the list of macros.
However, the .ppa file does not list macros. But, toolbar works fine.
So, should I pass ppt or ppa file as arguments to Application.Run()?
an example would be great.
Thankyou.

0 new messages