embedded object

[C Williams]

Hi,

I am trying to figure out how to create an object that users can insert
into Powerpoint and Excel by going to Insert-->Object (and I will
hopefully be able to insert one programmatically as well).

The behavior I need from my object is very similar to that of MS Graph.
I want to be able to go to "Insert-->Object", and instead of choosing
MSGraph, choose MyObject. Then, I would like to be able to click on the
created instance on the slide/worksheet and be able to format it--the
same way that a user can interact with MSGraph, but of course with
whatever functionality I write.

What is the best way to do this? I am getting a bit confused with
ActiveX controls/exes/dlls and OLE objects and not sure what to use. I
can create a control that can be added from the control toolbox, but not
through Insert-->Object. Also, I'm not sure how to go about adding to
it the functionality similar to MSGraph.

I truly appreciate any help you might be able to give me!

Thanks in advance,

-Casey

 

[Guest]

Hi,

Check: http://www.powerpointmagician.com/articles/dynamicppt.htm

Look at the sections titled "A Show in a Show" and "Visual Basic and
PowerPoint"

Glenna

 

[C Williams]

Thanks for the info, Glenna. However, I am already familiar with how to
insert existing objects, and I've worked a fair amount with VB and VBA
as they pertain to Powerpoint.

What I'm looking for specifically is how exactly to tell
Powerpoint/Excel about an (activex?) object I've written so that it will
appear in the dialog box that opens upon Insert-->Object. Also, I would
like to know how to set up interactions between powerpoint and my
object, as I described below (similar to how one interacts with msgraph).

Thanks for anything you or anyone else might be able to contribute!

-Csey

 

[Steve Rindsberg]

What I'm looking for specifically is how exactly to tell

Powerpoint/Excel about an (activex?) object I've written so that it will
appear in the dialog box that opens upon Insert-->Object. Also, I would
like to know how to set up interactions between powerpoint and my
object, as I described below (similar to how one interacts with msgraph).

You wouldn't need to tell PowerPoint about it specifically; it'd need to be a
server application that's registered with Windows itself. Beyond that, I'm
afraid I can't help much. MS Press has a book by Adam Denning (ActiveX
Controls Inside Out) that looks like it might be useful.

 

[C Williams]

Thanks, Steve--I'll check that book out. And yeah, you're right--I can
see that this isn't specific to PowerPoint or Excel, but I was hoping
(and still am!) that someone might have tried something like this before!

Thanks!

-Casey

 

[Steve Rindsberg]

Thanks, Steve--I'll check that book out. And yeah, you're right--I can
see that this isn't specific to PowerPoint or Excel, but I was hoping
(and still am!) that someone might have tried something like this before!

Certainly it's been done. You just need to find out how and by whom. ;-)

"Just" he says.

 

[C Williams]

Ah yes...the big "just." I will post back here if I figure it out
before someone else clues me in.

 

[Brian Reilly, MS MVP]

Casey,
Not that we are shabby programmers, but if I had to do this I'd try
and post this in the Excel Developers NG. Certainly the likes of MVP's
like Stephen Bullen and Rob Bovey, etc, have done this before.
Good luck.

Brian Reilly, PowerPoint MVP