Logging multiple pps

  • Thread starter Thread starter Jan G. Thorstensen
  • Start date Start date
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
 
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.
 
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.
 
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.
 
There are no events in PowerPoint 97, though if you were to open the files via
VBA/Macros rather than normal links, the macros could record information to
file.
 
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?
 
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.
Click to expand...

It's hard to say why the screen might freeze w/o stepping through the code, but
it does seem that it could be simpler in PPT itself.
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.
Click to expand...

Exactly, or perhaps a menu item that invokes a user form with combo boxes and
such on it.
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?
Click to expand...

No more than running both programs and not Alt+Tabbing would. I suppose if the
video driver or one or more of the programs had a resource/memory leak, it
could consume more resources/memory over time, but otherwise, I don't believe
there's any penalty.
 
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
 
Back
Top