By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,235 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,235 IT Pros & Developers. It's quick & easy.

placing a Python com object into Excel

P: n/a
Hi
I have seen examples from Mark Hammonds book where a Python COM object
is accessed from Excel with a VBA script. But, what if I want to Insert
a Python COM into the Sheet itself?

When I try this, a list of available objects appear. But my object isn't
on the list.

Anybody have any ideas?

Mathew
Mar 17 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi!

Perso, I started from "excelAddin.py" (in
C:\Python25\Lib\site-packages\win32com\demos).
And, I'm happy with the result (who run OK with Excel 2000, XP, 2007).

@-salutations
--
Michel Claveau

Mar 17 '08 #2

P: n/a
Thanks for the tip. But, instead of an AddIn, what if I want to be able
to insert an object? I see that the demo adds items to the windows
registry under \Excel\AddIns. Is there a similar location for the
"Insert Object" command?

yikes. More Excel programming than I'd like to know.

Mathew

Méta-MCI (MVP) wrote:
Hi!

Perso, I started from "excelAddin.py" (in
C:\Python25\Lib\site-packages\win32com\demos).
And, I'm happy with the result (who run OK with Excel 2000, XP, 2007).

@-salutations
Mar 18 '08 #3

P: n/a
Mathew <my*****@jpl.nasa.govwrote:
>Thanks for the tip. But, instead of an AddIn, what if I want to be able
to insert an object? I see that the demo adds items to the windows
registry under \Excel\AddIns. Is there a similar location for the
"Insert Object" command?
What you see there is the list of registered ActiveX controls. You need to
implement a few additional interfaces. I believe IOleInPlaceObject is
required to satisfy Excel.

http://msdn2.microsoft.com/en-us/library/aa751972.aspx
--
Tim Roberts, ti**@probo.com
Providenza & Boekelheide, Inc.
Mar 19 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.