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

OLE Automation: Bring PPT window to front after presentation is built

0 views
Skip to first unread message

Joe B

unread,
Feb 22, 2000, 3:00:00 AM2/22/00
to
(Access and PPT 97)
Using OLE automation to have Access create a PPT
presentation.

When using the "GetObject" method to create a PPT
presentation, Access doesn't relinquish control to
the PPT window, even though I've used commands such as:

<object name>.WindowState = ppWindowMaximized
<object name>.Visible = True

Therefore, the customer would have to know to switch to
PPT by him/herself via the task bar.

Question: What command should I use to force PPT to
be the the active window after building the
presentation via OLE automation?

<< Note: answer was provided by Rudy Ferrara and will
be appended to this question shortly >>

Joe B

unread,
Feb 22, 2000, 3:00:00 AM2/22/00
to
Many thanks to Rudy Ferrara for providing the following
answer:

After your command,

<object name>.Visible = True

Add the command,

<object name>.Activate


=-=-= Additional Notes =-=-=

Though you could also use the command,

AppActivate "Microsoft PowerPoint"

it would not be the preferred method, since some
Microsoft Office applications can have more than one
instance running (not PowerPoint, it can only have one),
and you might accidentally activate the wrong instance.


=-=-=-=-=

"Joe B" <j_je...@yahoo.com> wrote in message
news:On$cckVf$GA.257@cppssbbsa04...

0 new messages