Rejected Safe Mode action : Microsoft Excel.

[Guntram Ulrich]

Hello Newsgroup,

how can I catch the Error:

Rejected Safe Mode action : Microsoft Excel

and what is it?

I have an automation acript opening multiple Excel.exe
processes and sometimes when the amount of processes is
growing this error occurs.

Does anybody know whats happening?

Thanks for answers.

best regards,
Guntram

 

[Jim Vita]

Guntram,

How many processes are you creating and are you shutting them down
properly? In what language is your automation script written?

Thanks,

Jim

Jim Vita
Microsoft Developer Support

Microsoft Security Announcement: Have you installed the patch for Microsoft
Security Bulletin MS03-026? If not Microsoft strongly advises you to review
the information at the following link regarding Microsoft Security Bulletin
MS03-026 http://www.microsoft.com/security/security_bulletins/ms03-026.asp
and/or to visit Windows Update at http://windowsupdate.microsoft.com to
install the patch. Running the SCAN program from the Windows Update site
will help to insure you are current with all security patches, not just
MS03-026.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Guntram Ulrich]

I have written the script with ASP and sometimes there are
about 90 processes excel.exe.

With a lower amount this ist working very properly and the
process are terminated reliable after the session has
ended.

Do you have any idea why there are ocurring rejected safe
mode errors when the amount of processes ist raising?

-----Original Message-----

Guntram,

How many processes are you creating and are you shutting them down
properly? In what language is your automation script written?

Thanks,

Jim

Jim Vita
Microsoft Developer Support

Microsoft Security Announcement: Have you installed the patch for Microsoft
Security Bulletin MS03-026? If not Microsoft strongly advises you to review
the information at the following link regarding Microsoft Security Bulletin
MS03-026 http://www.microsoft.com/security/security_bulletins/ms03-
026.asp
and/or to visit Windows Update at

http://windowsupdate.microsoft.com to

 

[Jim Vita]

Hi Guntram,

There are problems doing Office automation in a server or unattended
environment, particularly when using ASP. The limitations of doing
server-side automation are described in the following KB article :

257757 INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/?id=257757

The problems are such that the environment is unsupported. I can give you
some guidance on how to get your application working , but since this is an
unsupported environment, I can't guarantee that the prbolem can be resolved.

Go to task manager and seen if you are getting an accumulation of Excel
processes. If so then Excel is not shutting down properly. Make sure you
are calling the quit method on the application object and setting the
object reference to nothing.

You probably want to try creating fewer application processes by opening
multiple work with the same instance of the application.

Another thing you should look for is the creation of temporary or hidden
Office objects. For example:


Dim objBook
objBook = objExlApp.Workbooks.Open(Filename:=strFileName)
set objBook = nothing

creates a temporary reference to an Excel Workbooks object that is never
release. This will prevent the Excel application from shutting down. The
fix for this issue is to create actual references to the intermediate
object that can be released. An example that fixes the above problem is
below:

Dim objBook
Dim objBooks
objBooks = objExlApp.Workbooks
objBook = objBooks.Open(Filename:=strFileName)
set objBooks = nothing
set objBook = nothing



Thanks,

Jim

Jim Vita
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.