ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cancelling Safe Mode Programatically (https://www.excelbanter.com/excel-programming/279048-cancelling-safe-mode-programatically.html)

Ken Tune

Cancelling Safe Mode Programatically
 
I have an application ( writtern in VB ) that makes use of
Excel to extract data from a largish no. of files.

Every so often, ( sometimes weeks apart ) an internal
error occurs and my VB call to

dim XCel as New Excel.Application

fails with a 'Cannot Create Object' error. If I open Excel
manually, after such an error, I am told an error has
occurred - do I wish to open in safe mode. If I open
normally and shut down, then my program will execute
without errors. However if I do not, every time the above
call is reached, the program raises an error.

Is there any way of overcoming this problem without
resorting to manual intervention?

Thanks in advance



All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com