Automatically show form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

danielexyz@hotmail.com - 06 Nov 2005 11:50 GMT

Hi all,
I'm trying to understand how powerpoint can run vba code when opening a
specific ppt file.
Is it possibile using only the code within the ppt?
Hope you can help.
Thanks,

Daniele

Reply to this Message

Steve Rindsberg - 07 Nov 2005 00:46 GMT

> Hi all,
> I'm trying to understand how powerpoint can run vba code when opening a
> specific ppt file.

Ah. That's an easy one. It can't.

PowerPoint won't run code as the result of opening a PPT file.

If you have an addin that traps events and there's some way to identify the
specific files you're after, you can get code to run when that type of file is
opened.

Whether that's of any use to you or not depends on the specifics of what you're
trying to do. Fill in some more details and we'll take it from there.

Most important question: Is this part of a solution that you'll distribute to
others?

> Is it possibile using only the code within the ppt?
> Hope you can help.
> Thanks,
>
> Daniele

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

danielexyz@hotmail.com - 08 Nov 2005 22:44 GMT

Steve,
thanks for your answer!
We need to implement this process:
1. users are asked to complete a vba form some mandatory information
stored in the custom properties field
2. users then attach some slides to complete description of the project
3. users save the ppt with the modifications

What is need is to:
- automatically enable the vba form on startup
- check data consistency before saving the ppt

Hope you can help!
Kind regards,
Daniele

Reply to this Message

Steve Rindsberg - 09 Nov 2005 05:40 GMT

> Steve,
> thanks for your answer!
[quoted text clipped - 6 lines]
> What is need is to:
> - automatically enable the vba form on startup

On startup of which, PowerPoint or a specific presentation?
And again, are you able to force users to install an addin and will they be
running PowerPoint rather than the free viewer?

> - check data consistency before saving the ppt
>
> Hope you can help!
> Kind regards,
> Daniele

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

danielexyz@hotmail.com - 09 Nov 2005 09:44 GMT

Steve,

>> What is need is to:
>> - automatically enable the vba form on startup

> On startup of which, PowerPoint or a specific presentation?
> And again, are you able to force users to install an addin and will they be
> running PowerPoint rather than the free viewer?

1. users should be asked to complete a vba form on startup of a
specific ppt file
2. yes, we ask our employees to install an adding
all the users have a full and licenced version of powerpoint.
Thanks,
Daniele

Reply to this Message

Steve Rindsberg - 09 Nov 2005 15:51 GMT

> Steve,
>
[quoted text clipped - 9 lines]
> 2. yes, we ask our employees to install an adding
> all the users have a full and licenced version of powerpoint.

OK, then you'll need to create an addin that includes event handlers.
For more on this, see:

Make PPT respond to events
http://www.rdpslides.com/pptfaq/FAQ00004.htm

Your addin can respond to the user's opening a presentation.
If it's not the file you're interested in, the addin can just ignore it, but if
it IS the specific presentation, the addin can bring up the form and do
whatever else is needed.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

danielexyz@hotmail.com - 09 Nov 2005 22:53 GMT

Steve,
very kind of you and really appreciated!
Thanks a lot
Daniele

Reply to this Message

Steve Rindsberg - 10 Nov 2005 00:00 GMT

> Steve,
> very kind of you and really appreciated!
> Thanks a lot
> Daniele

My pleasure ... let us know how you do with it, 'kay?

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message