Logging multiple pps

J

Jan G. Thorstensen

Hi. I am using PowerPoint 97
I have made a course using PowerPoint 97. It consist of more than 40 files
and I want each of these slide shows to log their file name and time their
are
opened (or run).

Now, in Excel, there is an event that is triggered every time you open the
workbook (file). It is named "sub Auto_Open()".

Is there a similar method for PowerPoint so that I can have my log macro
run automatically every time a new slide show starts running?

(The log file will be read and used of different Teachers stepping into the
course).
Thanks for any help.

Jan
 
B

B

This is very doable. The key to being able to do this is to either 1) make
your own or 2) load one of the already written event handlers. PowerPoint
only handles two events natively Auto-Open and Auto-Close and these are
program level, not presentation level. But, by installing the event
handlers you are able to capture many more events, such as presentation
open, close, save, print, start, end, and others.

Look here for more help. Welcome to the dark side.
**Make PPT respond to events**
http://www.rdpslides.com/pptfaq/FAQ00004.htm

B
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
 
J

Jan G. Thorstensen

Thank you for your answer.
However the Event handler was design for PowerPoint 2000+,
not PowerPoint '97.

So my question is:
Is there an event procedure in PowerPoint97 equivalent to the one
in Excel "Auto_Open" that will fire when the Excel file is opened.

Any help will be very much apprieciated.

Sincerely Jan

PS: I tried with

Sub Auto_Open()
MsgBox "This makro is executed when this file is opened."
End Sub

but with no success.
 
B

B

Sorry, missed the 97 part. To quote the page:
"PowerPoint 97 doesn't support events, so it can't automatically run macros
when a presentation opens, at print time, etc. "

Upgrades are relatively inexpensive, this may be your best option.

B
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
 
J

Jan G. Thorstensen

Thanks. And that is one of the thinks that I have tried.
I made a sort of front end in Excel where I had a form
with two Combo Boxes filled with folder names and
file names dependent of what folder was selected. The
user would here open the file of their choise with Excel
automating Power Point.

First it worked perfect, but after a while, it made
the screen freeze.?? So the users (teachers) are not very
happy with the solution. I thougt may be running a macro
directly from PPT could perhaps solve this problem.

There might be another solution perhaps creating an add in
with Combo Boxes at the menu and then let the user open
the pps from there. The add in could hold code that recorded
information to file.

Any comment is apprieciated, thanks.

Jan
---
PS. Also when the user run the slide shows, sometimes they
press Alt+Tab to switch to another program. They will show
some examples in this other program and then switch back to
power point pressing the Alt+Tab button again.

Does anybody know if this operation is using extra memory?
 
J

Jan G. Thorstensen

Well, I will try to make a solution using a menu item to open a form as an
add in that takes care of the logging.
Thanks for all of your comments and suggestions.

Jan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top