473,545 Members | 2,388 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Python COM Makepy Excel 9.0 error

Has anyone seen this? When I run the COM Makepy utility and choose
Microsoft Excel 9.0 Object Library (1.3), I get an application error
message:

PythonWin: Pythonwin.exe - Application Error
The instruction at "0x77fcc87" referenced memory at "0x0307a705 ". The
memory could not be "read".

I do not get this error when I choose the Microsoft Office 9.0 Object
Library (2.1).

I have tried this from one other computer and got a similar error
message. I looked all over the 'net for enlightenment and have so far
been unsuccessful. Does anyone have an idea what can be going on and
how to get around it?

I am using Python 2.4 under Windows 2000SP4. I have also installed
pywin32 (build 203 for Python 2.4) and py2exe-0.5.4 for Python 2.4.

Python 2.3 and the COM Makepy utility (Python 2.3 version) seems to run
okay.

I am writing a rather complicated set of instructions to manipulate a
series of Excel 2000 spreadsheets and have already added quite a few of
the features from Python 2.4, so I hope I do not have to revert back to
Python 2.3. Any suggestions?

Thank you, in advance,
Christopher D. Morgan, P.E., Ph.D.

Jul 18 '05 #1
2 2171
nv*****@gmail.c om wrote:
Has anyone seen this? When I run the COM Makepy utility and choose
Microsoft Excel 9.0 Object Library (1.3), I get an application error
message:

PythonWin: Pythonwin.exe - Application Error
The instruction at "0x77fcc87" referenced memory at "0x0307a705 ". The
memory could not be "read".

I do not get this error when I choose the Microsoft Office 9.0 Object
Library (2.1).

I have tried this from one other computer and got a similar error
message. I looked all over the 'net for enlightenment and have so far
been unsuccessful. Does anyone have an idea what can be going on and
how to get around it?

I am using Python 2.4 under Windows 2000SP4. I have also installed
pywin32 (build 203 for Python 2.4) and py2exe-0.5.4 for Python 2.4.

Python 2.3 and the COM Makepy utility (Python 2.3 version) seems to run
okay.

I am writing a rather complicated set of instructions to manipulate a
series of Excel 2000 spreadsheets and have already added quite a few of
the features from Python 2.4, so I hope I do not have to revert back to
Python 2.3. Any suggestions?

Thank you, in advance,
Christopher D. Morgan, P.E., Ph.D.

I experienced similar problems when moving some code from Python 2.3 to
Python 2.4. Seems that running "makepy -d ..." works. See Mark
Hammond's explanation at:

http://mail.python.org/pipermail/pyt...er/002743.html
[python-win32] WMI scripting makepy error with ActivePython 2.4.0

HTH,
Jim Sizelove
Jul 18 '05 #2
Thank you! That did the trick.

Jul 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
35498
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 and extract information from specific worksheets and cells. I'm not really sure how to get started with this process. I ran the COM Makepy...
5
2533
by: Reinhard Koenig | last post by:
Hello, I' m using Python 2.3, win32all-157 under W2K. I've applied the makepy utility for the Word 8.0 object library. I now receive: Python 2.3.1 (#47, Sep 23 2003, 23:47:32) on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import win32com.client >>> win32com.client.Dispatch("Word.Application")
3
2992
by: Annie | last post by:
I am trying to call a COM object which expects a variant datatype to be passed in to the COM API object. However, I get "<COMObject <unknown>>" and the program fails. Below is my code in Python, and the same code in VB which is working fine... I guess this is a variant problem with python? How can I make this work? Would appreciate if...
2
4008
by: Svenn-Ivar Svendsen | last post by:
Hi, I use the makepy tool in pythonwin to generate wrappers for my connection point (event) interfaces in a project. It works fine. The question is; Is it possible, in a python script, to detect if wrappers for COM (event) interfaces the script uses have been created, and in case not somehow call the makepy tool manually before proceeding?...
0
1735
by: Puneet Jain | last post by:
I am tryin to use Microsoft Works Wordprocessor from Python After generating the .py module from the type library using makepy utility, I runt he following commands, >>> from win32com.client import Dispatch >>> object = Dispatch("MicrosoftWorks.WordProcessor.AppControl") and I get the following error, Traceback (most recent call last):
1
1670
by: Matthew | last post by:
Hi: I recently installed Python 2.4 and the Win 32 extensions on Windows XP. I had some problems with the COM makepy utility for the Excel COM libraries. I reported this problem to the sourceforge bug tracker. My question is , is python 2.3 and the win32 extensions more stable than Python 2.4?
3
1807
by: Mudcat | last post by:
Howdy, I could have sworn I downloaded a version of python win that supported object library 11.0 at some point. However I just downloaded versions 204 and 203, and the highest version they have is OL 9.0. Does anyone know if this is a mistake or if Excel 2003 isn't yet supported with the extensions? Thanks,
3
3990
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 2000, but in Office 2003 crash at line: "wbc = workbook.VBProject.VBComponents.Add(1)" Please help me :-( the code of the module that crash is...
4
3446
by: suzhi18 | last post by:
Hallo, I've a problem getting makepy running. When I start the tool on my machine with doubleclick everything is fine. But when I try this in my Code: makepy.py -i "Microsoft Excel 11.0 Object Library(1.5)" I am getting an Syntax Error and command:
0
7487
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7420
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7680
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7778
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6003
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
4966
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3476
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3459
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1033
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.