PowerPoint Automation

May 12th, 2008 admin Posted in Articles No Comments »

The following comes from the Usenet group: Microsoft.Public.Office.developer.vba

Hello Howard Kaikow,
I have modified a little bit your procedure. As result I get same process
could you try it and see what happens.
I get same windows handle and processID for both PowerPoint instances

Note: I am with PowerPoint XP

Thank you for cooperation

Galin Iliev
MCSD

Option Explicit

Private Declare Function GetWindowThreadProcessId Lib “user32″ (ByVal hwnd
As Long, lpdwProcessId As Long) As Long
Private Declare Function GetForegroundWindow Lib “user32.dll” () As Long
Public Sub MultiplePowerpoints()
Dim appPowerpoint As PowerPoint.Application
Dim appPowerpointAnother As PowerPoint.Application
Dim appWord As Word.Application
Dim blnPPTRunning As Boolean
Dim lFirstID As Long
Dim lSecondID As Long
Dim lFirstHandle As Long
Dim lSecondHandle As Long

On Error Resume Next
Set appPowerpoint = GetObject(Class:=”PowerPoint.Application”)
If appPowerpoint Is Nothing Then
Powerpoint not running, create instance of Powerpoint
blnPPTRunning = False
Err.Clear
Set appPowerpoint = New PowerPoint.Application
MsgBox “Creating first instance of Powerpoint“, vbOKOnly, _
Powerpoint was not already running”
Else
blnPPTRunning = True
MsgBox “Using running instance of Powerpoint“, vbOKOnly, “Powerpoint
was already running”
End If
With appPowerpoint
.Visible = True
.Activate
lFirstHandle = GetForegroundWindow()
.WindowState = ppWindowMinimized
End With
‘ Create another instance of Powerpoint
Set appPowerpointAnother = New PowerPoint.Application
If appPowerpointAnother Is Nothing Then
With Err
MsgBox .Number & “: ” & .Description, vbOKOnly, “Could not
create second instance of Powerpoint
End With
Else
MsgBox “OK!”, vbOKOnly, “Created second instance of Powerpoint
With appPowerpointAnother
.Visible = True
.Activate
lSecondHandle = GetForegroundWindow()
.WindowState = ppWindowMinimized
End With
End If

‘Check processes IDs
GetWindowThreadProcessId lFirstHandle, lFirstID
GetWindowThreadProcessId lSecondHandle, lSecondID
If lFirstID = lSecondID Then MsgBox “appPowerpoint and appPowerpoint
hold same process!”

‘If this code started PowerPoint
If blnPPTRunning = False Then
If vbYes = MsgBox(”Select Yes to kill the First instance of
Powerpoint“, vbYesNo, _
Powerpoint hit squad needs your instructions”) Then
appPowerpoint.Quit
End If
End If

If vbYes = MsgBox(”Select Yes to kill the second instance of
Powerpoint“, vbYesNo, _
Powerpoint hit squad needs your instructions”) Then
appPowerpointAnother.Quit
End If

‘ Create another instance of Word
‘ Do not kill
Set appWord = New Word.Application
If appWord Is Nothing Then
With Err
MsgBox .Number & “: ” & .Description, vbOKOnly, “Could not
create second instance of Word”
End With
Else
MsgBox “OK!”, vbOKOnly, “Created second instance of Word”
With appWord
.Visible = True
.WindowState = wdWindowStateMinimize
End With
End If

Set appPowerpoint = Nothing
Set appPowerpointAnother = Nothing
Set appWord = Nothing

End Sub

AddThis Social Bookmark Button

New Viewer for Microsoft Office PowerPoint

May 12th, 2008 admin Posted in Articles No Comments »

The Following Comes from the Usenet Group Microsoft.Public.Powerpoint.

ello, I’m the lead program manager for Microsoft Office PowerPoint 2003.
Back in April I wrote to tell you about an exciting new PowerPoint Viewer we
were working on. Its my pleasure now to announce that we finished work a
short while ago, and that it is today available for download.

This new viewer has been engineered to support a number of new features from
our last few releases that were missing in the PowerPoint ‘97 Viewer.
Specifically, we’ve added support for the new animation effects,
simultaneous animations, and transitions. We’ve also added a number of
non-animation features, such as opening password protected documents. A new
twist here is that this viewer requires no installation, no setup of any
kind, and can run directly from write-protected media like CDs. This was
very important as the new viewer is a big part of the Package for CD feature
in Microsoft Office PowerPoint 2003, which I hope you’ll check out when it
becomes available in a few weeks. We’re very happy with the results and
hope you will be as well.

The viewer has just been posted, and is not yet linked into the Microsoft
Office web pages, so you’ll have to search the
http://www.microsoft.com/downloads section for “powerpoint 2003 viewer” to
find it. Links in the Microsoft Office web site will be showing up shortly.

Again, I want to acknowledge your contributions that helped us in defining
the features in this viewer. The feedback we get from MSWISH has been
essential in prioritizing and developing this application. The PowerPoint
MVPs are also to be thanked, as they do a great job of representing your
concerns and problems to us on a regular basis.

Thank you all.

Richard Bretschneider
Lead Program Manager
PowerPoint

AddThis Social Bookmark Button

Planning Presentation

February 17th, 2008 Ashfaq Posted in Articles No Comments »

Short and Sweet

One way to polish the presentation of the main point of your speech is to consider it thus. The day before your presentation, you are called to the office of the divisional vice-president; there you are introduced to the managing director and a representative of the company’s major share holder; “O.K.” says the vice president “we hear you have got something to say, we’ll give you 30 seconds, GO“. Can you do it?

If you can crystallize your thoughts and combine your main message with some memorable phrase or imagery, and present those both in 30 seconds then you have either the perfect ending or the basis for a fine presentation.

The Narrative

Everyone loves a story and stories can both instruct and convey a message: Zen Philosophy is recorded in its stories, and Christianity was originally taught in parables. If you can weave your message into a story or a personal anecdote, then you can have them wanting to hear your every word - even if you have to make it up.

Rehearsal

There is no substitute for rehearsal. You can do it in front of a mirror, or to an empty theatre. In both cases, you should accentuate your gestures and vocal projection so that you get used to the sound and sight of yourself. Do not be put off by the mirror - remember: you see a lot less of yourself than your friends do.

Relaxation

If you get nervous just before the show, either concentrate on controlling your breathing or welcome the extra adrenaline. The good news is that the audience will never notice your nerves nearly as much as you think. Similarly, if you dry-up in the middle - smile, look at your notes, and take your time. The silence will seem long to you, but less so to the audience.

Conclusion

Once the speech is over and you have calmed down, you should try to honestly evaluate your performance. Either alone, or with the help of a friend in the audience, decides what was the least successful aspect of your presentation and resolve to concentrate on that point in the next talk you give. If it is a problem associated with the preparation, then deal with it there; if it is a problem with your delivery, write yourself a reminder note and put it in front of you at the next talk.

Practice is only productive when you make a positive effort to improve - try it.

 

AddThis Social Bookmark Button

The techniques of the Speech

February 17th, 2008 Ashfaq Posted in Articles No Comments »

Every speaker has a set of “tricks of the trade” which he or she holds dear - the following are a short selection of such advice taken from various sources.

Make an impression

The average audience is very busy: they have husbands and wives, schedules and slippages, cars and mortgages; and although they will be trying very hard to concentrate on your speech, their minds will inevitably stray. Your job is to do something, anything, which captures their attention and makes a lasting impression upon them. Once you have planned your speech and honed it down to its few salient points, isolate the most important and devise some method to make it stick.

Repeat, Repeat

The average audience is very busy: they have husbands or wives etc, etc - but repetition makes them hear. The average audience is easily distracted, and their attention will slip during the most important message of your speech - so repeat it. You don’t necessarily have to use the resonant tonal sounds of the repeated phrase, but simply make the point again and again and again with different explanations and in different ways. The classic advice of the Sergeant Major is: “First you tell ‘me what you are going to tell ‘me, then you tell ‘me, then you tell ‘me what you told ‘me!”

Draw a Sign

Research into teaching has yielded the following observation: “We found that students who failed to get the point did so because they were not looking for it”. If the audience knows when to listen, they will. So tell them: the important point is….

Draw a Picture

The human brain is used to dealing with images, and this ability can be used to make the message more memorable. This means using metaphors or analogies to express your message. Thus a phrase like “we need to increase the market penetration before there will be sufficient profits for a pay related bonus” becomes “we need a bigger slice of the cake before the feast”.

Jokes

The set piece joke can work very well, but it can also lead to disaster. You must choose a joke which is apt, and one which will not offend any member of the audience. This advice tends to rule out all racist, sexist or generally rude jokes. If this seems to rule out all the jokes you can think of, then you should avoid jokes in a speech.

Amusing asides are also useful in maintaining the attention of the audience, and for relieving the tension of the speech. If this comes naturally to you, then it is a useful tool for pacing your delivery to allow periods of relaxation in between your sign-posted major points.

AddThis Social Bookmark Button

Delivery of Presentation

February 17th, 2008 Ashfaq Posted in Articles No Comments »

“The human body is truly fascinating - there are some I could watch all day” - Anon

Whatever you say and whatever you show; it is you, yourself which will remain the focus of the audience’s attention. If you but strut and fret your hour upon the stage and then are gone, no-one will remember what you said. The presenter has the power both to kill the message and to enhance it a hundred times beyond its worth. Your job as a manager is to use the potential of the presentation to ensure that the audience is motivated and inspired rather than disconcerted or distracted. There are five key facets of the human body which deserve attention in presentation skills: the eyes, the voice, the expression, the appearance, and how you stand.

The Eyes

The eyes are said to be the key to the soul and are therefore the first and most effective weapon in convincing the audience of your honesty, openness and confidence in the objectives of your presentation. This impression may of course be totally false, but here is how to convey it.

Even when in casual conversation, your feelings of friendship and intimacy can be evaluated by the intensity and duration of eye contact. During the presentation you should use this to enhance your rapport with the audience by establishing eye contact with each and every member of the audience as often as possible. For small groups this is clearly possible but it can also be achieved in large auditoriums since the further the audience is away from the presenter the harder it is to tell precisely where he or she is looking. Thus by simply staring at a group of people at the back of a lecture theatre it is possible to convince each of them individually that he or she is the object of your attention. During presentations, try to hold your gaze fixed in specific directions for five or six seconds at a time. Shortly after each change in position, a slight smile will convince each person in that direction that you have seen and acknowledged them.

The Voice

After the eyes comes the voice, and the two most important aspects of the voice for the public speaker are projection and variation. It is important to realize from the onset that few people can take their ordinary conversation voice and put it on stage. If you can, then perhaps you should move to Hollywood. The main difference comes in the degree of feedback which you can expect from the person to whom you are talking. In ordinary conversation you can see from the expression, perhaps a subtle movement of the eye, when a word or phrase has been missed or misunderstood. In front of an audience you have to make sure that this never happens. The simple advice is to slow down and to take your time. Remember the audience is constrained by good manners not to interrupt you so there is no need to maintain a constant flow of sound. A safe style is to be slightly louder and slightly slower than a fire-side chat with slightly deaf aunt. As you get used to the sound, you can adjust it by watching the audience.

 

AddThis Social Bookmark Button