Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > Python/Excel VBComponents crash

Thread Tools

Python/Excel VBComponents crash

Mark Carter
Posts: n/a
I use Office 2000, and I have recently upgraded to python 2.3 and

The following code worked in python 2.2:

xlApp = Dispatch("Excel.Application")
xlApp.Visible = 1
xlApp.ActiveWorkbook.SaveAs(sys.path[0] + '\\temp.xls')
wb = xlApp.Workbooks("temp.xls")
wbc = wb.VBProject.VBComponents # <---- CAUSES CRASH IN 2.3
del xlApp

but I get a GPE in 2.3, when the code finishes execution:
EXCEL caused an invalid page fault in
module OLE32.DLL at 0167:65f18ae3.

If you comment out the line
wbc = ...
then I get no GPE.
Any ideas?
Reply With Quote
Mark Carter
Posts: n/a
> Mark Carter wrote:
> > wbc = wb.VBProject.VBComponents # <---- CAUSES CRASH IN 2.3

> I think this is a bug in Excel,

I had raised this as issue 785258 in Sourceforge's pywin32 page. Your
response has been added to the issue, and I reclassified the issue as
Invalid (because we are saying that it was raised in error).
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
USR2216 WiFi card causes Win XP to crash - newbie need help! David Leslie Wireless Networking 3 01-22-2005 05:17 PM
WI-FI PCMCIA card causing Vaio GRX laptop to crash a boot =?Utf-8?B?QXJyYW4=?= Wireless Networking 2 10-23-2004 10:52 PM
Crash Course in Wireless In A Business Environment David Reed Wireless Networking 0 08-11-2004 06:06 PM
CRASH - DirectX End-User runtime - CRASH - What to to ? reply@newsgroup.please Computer Support 1 01-05-2004 02:55 PM