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 3 2436
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
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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Allison Bailey |
last post by:
Hi Folks,
I'm a brand new Python programmer, so please point me in the right
direction if this is not the best forum for this question....
I would like to open an existing MS Excel spreadsheet...
|
by: justin worrall |
last post by:
Hi,
I have a very simple python win32 example (gleaned from the O'Reilly
book on Win32 programming for Python), of an Excel client with a COM
server. Essentially I have three VB buttons -...
|
by: Kevin T. Ryan |
last post by:
Hi Group -
I have written a "semi-program" in MS Excel related to running a football
pool. I've updated it over the past two years or so, to the point where it
is getting pretty advanced. ...
|
by: Andrew Dalke |
last post by:
Is there an author index for the new version of the
Python cookbook? As a contributor I got my comp version
delivered today and my ego wanted some gratification.
I couldn't find my entries.
...
|
by: Gerry Blais |
last post by:
Newbie questions:
Suppose abc.xls has sheets a, b, c.
How can I find, in Python, the sheet names?
Given a sheet name, how can I export the sheet as a csv file?
Finally, how can I, in...
|
by: dan_roman |
last post by:
Hi,
I developed a script with a nice interface in Tkinter that allows me to
edit some formulas and to generate an Excel worksheet with VBA macros
within it. The script runs perfectlly in Office...
|
by: Clement |
last post by:
I am newbie to Python...... i want to know something..........
can i place an object in disk instead of placing in Main Memory...?
If possible, can you please explain with some scripts...?
...
|
by: Girish |
last post by:
Hi,
I want to embed a txt document into an excel using python.
Here is my code, but i get an error message
===================================================
Traceback (most recent call...
|
by: nphankey |
last post by:
I'm struggling to tame Excel using Python and COM.
Most of the following code is working except for the setting of the activesheet.
Also, I would like to know how to release a COM object...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |