Hi,

The reason the ppt is displaying top left of screen is the userform
handle is incorrect. In VBA userform do not have a built-in hWnd
property. So you need to use FindWindow to get the handle.
It will appear top left of userform. Forms 2.0 controls are windowless
controls and as such have no handle so you can not get it to appear in
the frame.


I lifted this code example from Stephen Bullen's site. Specifically the
FormFun example.
http://www.oaltd.co.uk/Excel/Default.htm

in the cmdShow_Click event you need to get the userforms handle.

Dim lngfrm_hWnd As Long

' get handle to userform
lngfrm_hWnd = FindWindow("ThunderDFrame", 0&) 'XL2000+

and use it later, here

screenClasshWnd = FindWindow("screenClass", 0&)
SetParent screenClasshWnd, lngfrm_hWnd

Cheers
Andy

wrote:
Well, I got it working, sort of... It displays the show, small and the
size of the frame, but not in the frame... It displays at the top left
corner of the monitor. no errors though!

If you are interested in trying it:
http://www.rickycampbell.com/temp/TestPPShow.xls

I had to make a few mods, mostly because it is VBA and not VB. If
anyone has a suggestion...

On Apr 1, 2:34 pm, Steve Rindsberg wrote:

While this code looks closer to getting where I would like to go, I am
using VBA not VB, and cannot open the VB project file nor the form
enclosed in the VBA editor. I've tried to convert as much as possible
but I am stuck on what control is on the form to display the show in,
and if it is even possible to use this control in VBA.

You can open the form file (.FRM) in a text editor and extract the code that way.

The form seems only to have a couple of buttons, a frame and a label, so it doesn't
look like anything you couldn't replicate in VBA. Haven't tried it myself, so I
can't say whether you'd run into other issues though.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
============================================== ==



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info