Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Office SP2 update causes Excel automation crash!

Help!

A client's server was automatically updated to MS Office 2003 SP2 at 3am
this morning. Normally this would be wonderful, but a Windows Service that I
had written, that runs on that server, and that utilizes Excel is now
crashing everytime it tries to open (via automation) a spreadsheet. Aarghhh!

The Event Log says first, "Rejected Safe Mode action: Microsoft Office
Excel."

Next event in the log says, "Faulting application excel.exe, version
11.0.6560.0, stamp 4296b6f2, faulting module mso.dll, version 11.0.6568.0,
stamp 42e18ef6, debug? 0, fault address 0x0003446c."

This application has been working just flawlessly for over a year, and was
working fine yesterday. As of the update at 3am this morning, it stops
working. I have to assume there's a connection.

Anybody able to give me a clue?

Rob Schripsema
DeWaard and Jones Company



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default Office SP2 update causes Excel automation crash!

To hazard a general guess (I have Excel 97 here), I would check
settings related to macros and security. You may have to allow macros
without digital signatures.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Office SP2 update causes Excel automation crash!

Rob.

Office starts in safe mode when one of it's startup services fails.
So it gives you an error message telling you it's starting in safe
mode.

Open Excel interactively. Go Help About and click the Disabled Items
button. To fix the problem might be as simple as re-enabling the
disabled service."

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Schripsema wrote in

Help!

A client's server was automatically updated to MS Office 2003 SP2 at
3am this morning. Normally this would be wonderful, but a Windows
Service that I had written, that runs on that server, and that
utilizes Excel is now crashing everytime it tries to open (via
automation) a spreadsheet. Aarghhh!

The Event Log says first, "Rejected Safe Mode action: Microsoft Office
Excel."

Next event in the log says, "Faulting application excel.exe, version
11.0.6560.0, stamp 4296b6f2, faulting module mso.dll, version
11.0.6568.0, stamp 42e18ef6, debug? 0, fault address 0x0003446c."

This application has been working just flawlessly for over a year,
and was working fine yesterday. As of the update at 3am this morning,
it stops working. I have to assume there's a connection.

Anybody able to give me a clue?

Rob Schripsema
DeWaard and Jones Company

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Office SP2 update causes Excel automation crash!

Thanks for the note. Turns out, however, it was something completely
different.

We're going against Microsoft's current recommendations and using Office
Automation (of Excel) as part of a Windows Service that periodically checks
an email queue, extracts spreadsheet attachments, parses them, and applies
order data they contain (after much validation checking) to an order
fulfillment queue.

The line in my app (C#) that says, "ExApp = new Excel.Application();" has
worked flawlessly -- until the update. Suddenly it was causing the internal
fault that killed the process.

I was also using something less than a "best practice" in that we were
running the service under the LocalSystem account. Again, has worked just
fine for a long time.

Solution: Create a local machine user account on the server, and run the
service under that account instead.

Everything is working just fine now.

Hope that helps somebody else! And I've learned my lesson. AND, the client
will be encouraged to fund the development required to create a web service
to handle incoming orders, rather than having spreadsheets mailed in. Of
course, that will also mean the dozens of clients they have who are already
emailing in these spreadsheets will have to change all of their practices as
well. ($igh).

Rob

"keepITcool" wrote in message
.com...
Rob.

Office starts in safe mode when one of it's startup services fails.
So it gives you an error message telling you it's starting in safe
mode.

Open Excel interactively. Go Help About and click the Disabled Items
button. To fix the problem might be as simple as re-enabling the
disabled service."

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Schripsema wrote in

Help!

A client's server was automatically updated to MS Office 2003 SP2 at
3am this morning. Normally this would be wonderful, but a Windows
Service that I had written, that runs on that server, and that
utilizes Excel is now crashing everytime it tries to open (via
automation) a spreadsheet. Aarghhh!

The Event Log says first, "Rejected Safe Mode action: Microsoft Office
Excel."

Next event in the log says, "Faulting application excel.exe, version
11.0.6560.0, stamp 4296b6f2, faulting module mso.dll, version
11.0.6568.0, stamp 42e18ef6, debug? 0, fault address 0x0003446c."

This application has been working just flawlessly for over a year,
and was working fine yesterday. As of the update at 3am this morning,
it stops working. I have to assume there's a connection.

Anybody able to give me a clue?

Rob Schripsema
DeWaard and Jones Company



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default Office SP2 update causes Excel automation crash!

i got updated overnight too,

there seems to be a bug in the SP2 regarding the Drawing Toolbar.

in my original installation i had disabled ClipArt in Office setup the
entire tree Office SharedFeatures/ClipOrgananizer was set to
NotAvailable.


I narrowed it down to the visibility of the Drawing Toolbar.
Displaying that ran without problems in SP1 (even with clipart
disabled.)

After installing SP2 excel continuously disaplys error messages
"Can't display Clipart"", while the "Drawing" Toolbar is visible.
and ClipArt is not installed.

HTH.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Schripsema wrote in

Help!

A client's server was automatically updated to MS Office 2003 SP2 at
3am this morning. Normally this would be wonderful, but a Windows
Service that I had written, that runs on that server, and that
utilizes Excel is now crashing everytime it tries to open (via
automation) a spreadsheet. Aarghhh!

The Event Log says first, "Rejected Safe Mode action: Microsoft Office
Excel."

Next event in the log says, "Faulting application excel.exe, version
11.0.6560.0, stamp 4296b6f2, faulting module mso.dll, version
11.0.6568.0, stamp 42e18ef6, debug? 0, fault address 0x0003446c."

This application has been working just flawlessly for over a year,
and was working fine yesterday. As of the update at 3am this morning,
it stops working. I have to assume there's a connection.

Anybody able to give me a clue?

Rob Schripsema
DeWaard and Jones Company



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel & Access (Office XP) crash malcolm Excel Discussion (Misc queries) 0 February 7th 07 02:09 PM
office automation Word-Excel pggardner Excel Programming 2 April 2nd 04 09:16 PM
Office automation application which will work with any version of office C#.NET Silly Programmer Excel Programming 1 February 21st 04 10:54 AM
RP - Office 2000 automation parameters Access and excel Matt. Excel Programming 5 December 16th 03 07:55 PM
Office 2000: excel to access automation and parameters Matt. Excel Programming 0 December 15th 03 09:33 PM


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"