T
Tony B.
I'm using MS Word to automate creating a PowerPoint presentation from a Web
link which does so quite neatly. When the user clicks on the Web link, I
instantiate Word by using a new ActiveX object (Word.Application) to open a
read-only version of a Word document. Once the document opens, the
Document_Open() procedure fires automatically and runs the code to create
the presentation.
The whole purpose of this is our company wants to remove all source *.ppt
files from the server for security reasons and to save space. Thus, we had
to come up with a way to reconstruct presentations exported for viewing on
our Intranet (using a tool I developed) in .png format. Since PowerPoint
doesn't allow us to do this from the Web, we run Word in the background to
do the work which maybe causing some resource issues.
Before running the process, I prompt the user with a MsgBox asking them if
they want to continue. If they choose not to continue, we kill the whole
process by closing the document and releasing all resources. As the
process is running, Word is quietly running (creating the presentation) in
the background (visible="false"). Once the presentation is created, we
close Word and release resources used.
The only problem I'm am having is whenever the user clicks OK to start the
process, I have to momentarily make the PowerPoint window visible when the
presentation is initially created. Since PowerPoint doesn't support using
Application.Visible="msoFalse", I have to immediately minimize the
application window so it's not visible to the user during the presentation
build. However, when I do this, it leaves an imprint of the PowerPoint
window in the background which I can't seem to get rid of until I prompt the
user to save the newly created presentation to a location of their choice.
I really don't want the user to see anything, after they click OK to start
the process, until they are prompted to save the presentation.
Is there a way to clear this so users don't see this because it looks kind
of messy??? Also, while the presentation is being built, the user can't
click anything to remove/minimize the window since this process making CPU
work pretty hard. Any recommendations on making this run smoother would be
great. This is a really scaled down version.
Tony B.
link which does so quite neatly. When the user clicks on the Web link, I
instantiate Word by using a new ActiveX object (Word.Application) to open a
read-only version of a Word document. Once the document opens, the
Document_Open() procedure fires automatically and runs the code to create
the presentation.
The whole purpose of this is our company wants to remove all source *.ppt
files from the server for security reasons and to save space. Thus, we had
to come up with a way to reconstruct presentations exported for viewing on
our Intranet (using a tool I developed) in .png format. Since PowerPoint
doesn't allow us to do this from the Web, we run Word in the background to
do the work which maybe causing some resource issues.
Before running the process, I prompt the user with a MsgBox asking them if
they want to continue. If they choose not to continue, we kill the whole
process by closing the document and releasing all resources. As the
process is running, Word is quietly running (creating the presentation) in
the background (visible="false"). Once the presentation is created, we
close Word and release resources used.
The only problem I'm am having is whenever the user clicks OK to start the
process, I have to momentarily make the PowerPoint window visible when the
presentation is initially created. Since PowerPoint doesn't support using
Application.Visible="msoFalse", I have to immediately minimize the
application window so it's not visible to the user during the presentation
build. However, when I do this, it leaves an imprint of the PowerPoint
window in the background which I can't seem to get rid of until I prompt the
user to save the newly created presentation to a location of their choice.
I really don't want the user to see anything, after they click OK to start
the process, until they are prompted to save the presentation.
Is there a way to clear this so users don't see this because it looks kind
of messy??? Also, while the presentation is being built, the user can't
click anything to remove/minimize the window since this process making CPU
work pretty hard. Any recommendations on making this run smoother would be
great. This is a really scaled down version.
Tony B.