Hyperlinks and hidden windows - a possibility???

  • Thread starter Thread starter Colleyville Alan
  • Start date Start date
C

Colleyville Alan

I wrote an app in MS Access that would open PPT files and copy specific
slides within these files to a new presentation, thus customizing it for a
particular customer.

I opened these files with the "withwindow" property set to false, thus
hiding the windows and speeding up performance. That program was running
many clients in a looping structure and in a batch mode. Now I have revised
that code for interactive use and the user manually opens the files and the
looping code finds the relevant slides via a followhyperlink command.

Is it possible to have open PPT windows, go to the proper slides via the
hyperlink, copy and paste them back to a target presentation and do all of
this while "hiding" a window? I have not been able to do that, nor have I
been able to even have PPT in a small window size (I manually resized it
prior to running, and it jumped to a 1/2 screen size).

My biggest desire: I'd lke my Access app to display a progress label with
one of those "now processing slide 2 of 10" msgs, but when the hyperlinks
take over, I lose sight of Access and do not get it back even when PPT
finishes.

Any suggestions welcome.
Thanks.
 
Is it possible to have open PPT windows, go to the proper slides via the
hyperlink, copy and paste them back to a target presentation and do all of
this while "hiding" a window? I have not been able to do that, nor have I
been able to even have PPT in a small window size (I manually resized it
prior to running, and it jumped to a 1/2 screen size).
Click to expand...

What about minimizing the app to the toolbar ( oPPTApp.Minimize for example )?
My biggest desire: I'd lke my Access app to display a progress label with
one of those "now processing slide 2 of 10" msgs, but when the hyperlinks
take over, I lose sight of Access and do not get it back even when PPT
finishes.
Click to expand...

There are API calls to find a specific window and bring it to the front.
I think you can find code for this at Randy Birch's VBNet site ( not to worry,
the whole DotNet thing came long after he named the site - this is VB dot NOT
dotnet <g>)

http://vbnet.mvps.org/

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
Steve Rindsberg said:
What about minimizing the app to the toolbar ( oPPTApp.Minimize for
Click to expand...
example )?

I could not find "minimize" at the application level. I assume this is what
you meant?

oPPT.WindowState = ppWindowMinimized

There are API calls to find a specific window and bring it to the front.
I think you can find code for this at Randy Birch's VBNet site ( not to worry,
the whole DotNet thing came long after he named the site - this is VB dot NOT
dotnet <g>)
Click to expand...

I had hoped to avoid API calls since I have never used them and anything
new, while it may be simple, always feels like it is going to involve six
weeks of work and 45 calls for help. I had hoped that the AppActivate
command would do the trick, but so far it does not. So it looks like the
API may be the way to go.
Thanks
 
Steve Rindsberg said:
What about minimizing the app to the toolbar ( oPPTApp.Minimize for
Click to expand...
example )?

I could not find "minimize" at the application level. I assume this is what
you meant?

oPPT.WindowState = ppWindowMinimized

There are API calls to find a specific window and bring it to the front.
I think you can find code for this at Randy Birch's VBNet site ( not to worry,
the whole DotNet thing came long after he named the site - this is VB dot NOT
dotnet <g>)
Click to expand...

I had hoped to avoid API calls since I have never used them and anything
new, while it may be simple, always feels like it is going to involve six
weeks of work and 45 calls for help. I had hoped that the AppActivate
command would do the trick, but so far it does not. So it looks like the
API may be the way to go.
Thanks
 
I could not find "minimize" at the application level. I assume this is what
you meant?

oPPT.WindowState = ppWindowMinimized
Click to expand...

Dang. Every time I shoot from the hip, I get it in the teeth. Yep, that's it.
Thanks.
I had hoped to avoid API calls since I have never used them and anything
new, while it may be simple, always feels like it is going to involve six
weeks of work and 45 calls for help.
Click to expand...

I know the feeling. But have a look at Randy's site; most of the examples are
so well done that it's just a matter of a bit of intelligent copy/paste into
PPT/VB/Wherever.

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
Steve Rindsberg said:
Dang. Every time I shoot from the hip, I get it in the teeth. Yep, that's it.
Thanks.


I know the feeling. But have a look at Randy's site; most of the examples are
so well done that it's just a matter of a bit of intelligent copy/paste into
PPT/VB/Wherever.
Click to expand...


Looks like "oAccessApp.RunCommand acCmdAppMaximize" took care of the trick.
The other maximize cmd I had for Access maximized the window within the
application, not the application itself so no need for API calls. Thanks
for the help.
 
Looks like "oAccessApp.RunCommand acCmdAppMaximize" took care of the trick.
The other maximize cmd I had for Access maximized the window within the
application, not the application itself so no need for API calls. Thanks
for the help.
Click to expand...

Great! Not that I was that much help, but if it got you pointed in the right
direction, I'll share some of the credit. ;-)

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
What You want to do is first to create the hyperlinks. Then open it, and
click copy. Then Right Click On The Minimize button on the task bar to make
sure it is the default window and click paste.



From: Ben Fryxell, age 9, computer geek
 
Hi,
I haven't understood this clearly:
Is it possible to have open PPT windows, go to the proper slides via the
hyperlink, copy and paste them back to a target presentation and do all of
this while "hiding" a window?
Click to expand...
 
Back
Top