Open Linked application in Power Point

[Guest]

I need some help here. I hope someone could help.

1) When I double click the linked or embed application in power point, it
is open in-place. Not a separate window is used. Is there a means of
expanding this open embeded application to full screen?? I would like to do
this in VBA code.

2) I noticed that I can manually drag the in-place window to a larger size.
Can I maximize this or enlarge it by using VBA code and How??

3) If I was using embed VBA Code in the power point, Can I have the VBA
code located somewhere else, such that it is referenced??? The reason is
that I am using VBA Code to generate the power point currently. I don't know
how to embed VBA code into the application by using VBA Code. Can someone
help??

4) When I open the embed application by using Edit -> Visio -> Open, it
open the embed Visio application in its own window. If I can't get the
in-placed open window to full screen, the separate window does get
full-screen. The problem is getting the application to open in its separate
window by double clicking. The double clicking opens it in-place and not in
a separate window. How can I change that such that double clicking the
application will open in a separate window.

I really need some help here!!

Thank You,

G

 

[Guest]

Simmom, are you sure that is embedding? Have you trial run it?

 

[Guest]

camxaxle, i am sorry to tell you that it is not embeded. The PowerPoint just
build a link between them. I am sorry that I didn't note the word "embeded"
and it 's a pity that my idea could not be help!

 

[Guest]

Gary, to insert an application into PowerPoint, you can follow the steps show
below:
1.Click on "Slide Show," then "Action Buttons."
2.Choose the "blank" button.
3.Drag a box in the lower-right corner of your slide. In the dialog box that
pops up, check Run Program and browse to the aplication you want to be
embeded.
4.Click OK.
The button you created will link this slide show to the aplication. then you
can do things like change the appearance of the button.

 

[Steve Rindsberg]

1) When I double click the linked or embed application in power point, it

is open in-place. Not a separate window is used. Is there a means of
expanding this open embeded application to full screen?? I would like to do
this in VBA code.

Try something like this:

Dim oSh as Shape
Set oSh = ActiveWindow.Selection.ShapeRange(1)
If oSh.Type = 7 Then ' an embedded OLE object
oSh.OLEFormat.DoVerb Index:=2
End If

2) I noticed that I can manually drag the in-place window to a larger size.
Can I maximize this or enlarge it by using VBA code and How??

I don't have a answer for that one.

3) If I was using embed VBA Code in the power point, Can I have the VBA
code located somewhere else, such that it is referenced??? The reason is
that I am using VBA Code to generate the power point currently. I don't know
how to embed VBA code into the application by using VBA Code.

To make sure of what you're asking, here's how I understand it:

You have an application that's creating a PPT presentation by automating
PowerPoint.

You want to create the presentation in such a way that your code to manipulate
embedded shapes is somehow included in the PPT you create or at least available
to it.

Is that roughly correct? The problem is working out how you're going to get
your code to run more than getting the code into PPT in the first place.

PowerPoint won't automatically run code from a PPT file unless the user's
viewing the presentation in slideshow view and clicks on a shape you've assigned
a Run Macro action setting to.

On the other hand, if you put your code in an add-in and can get the user to
install that, the addin could create a toolbar with buttons the user can click
to trigger your code.

4) When I open the embed application by using Edit -> Visio -> Open, it
open the embed Visio application in its own window. If I can't get the
in-placed open window to full screen, the separate window does get
full-screen. The problem is getting the application to open in its separate
window by double clicking. The double clicking opens it in-place and not in
a separate window. How can I change that such that double clicking the
application will open in a separate window.

I don't know of any way to change the doubleclick behavior. That's built into
PPT and as such, not accessible as far as I know.

 

[Guest]

Thank you for noticing the embed application.

Your responds for item #1, where should this code be placed??

Looks like you are setting VERB = 2 which causes it to open it is own screen.

It looks like you are using the activewindow and making the shade have a
verb=2.

I am still not sure where to to the code at??? Its not like access where
there is an OnOpen event, or the ability to preset a form to have Verb =2.

On Item #3, you are correct on your assumption. I was think that if I can
detect the fact that an OnOpen event occur, then act. But you right, the new
power point will not have any code in it because I generated using VBA code
from Access, OLE with Power Point and Visio. So you think its my be only
possible to have a button to load the Add-in?? What is an Add-in (It sounds
like code some where). I may work.


Thank You,

G

 

[Steve Rindsberg]

Thank you for noticing the embed application.

Your responds for item #1, where should this code be placed??

Looks like you are setting VERB = 2 which causes it to open it is own screen.

It looks like you are using the activewindow and making the shade have a
verb=2.

Invoking Verb=2 on the OLE object represented by the current selected shape, yes.

I am still not sure where to to the code at??? Its not like access where
there is an OnOpen event, or the ability to preset a form to have Verb =2.

On Item #3, you are correct on your assumption. I was think that if I can
detect the fact that an OnOpen event occur, then act. But you right, the new
power point will not have any code in it because I generated using VBA code
from Access, OLE with Power Point and Visio. So you think its my be only
possible to have a button to load the Add-in?? What is an Add-in (It sounds
like code some where). I may work.

Yes, an addin is basically a PPT file that includes only vba code and that's been
saved in a special way.

Have a look through this section of the PPT FAQ:

For VBeginners
http://www.rdpslides.com/pptfaq/index.html#For_VBeginners

I understand that you're not a beginner, but this'll help get you up to speed in the
PPT version of VB/VBA.

There's also a section that explains add-ins.