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 >>
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...