Help! "Automation Error, Catastrophic failure"

[JJ59]

Dear all,

Could someone tell me why I have such error message?

I wrote macros and user defined functions in my spreadsheet, which can also import dynamic data from quote system. In addition, I also select a new web query.

Everything looks fine but after I close the spreadsheet and reopen it, it just shows

"Automation Error, Catastrophic failure" and it seems that the spreadsheet got stock when calculating the UDF.

Please help! I think a macro and UDF should work well in the same spreadsheet, right?

Thanks very much,

jj

 

[XL-Dennis]

JJ59

Propably a reference that is broken/missing...

Open the VB-editor. Choose Tools | References... and uncheck any reference named ISMISSING.

HTH,
Dennis

 

[JJ59]

Thanks for the reply. Dennis

I can't 'find "ISMISSING" in the reference.

I'm using Excel 2000 with XP. I don't know if that is the reason but I got another weird problem:

I wrote a small macro to call Solver in the questionable spreadsheet. It only has four spreadsheets initially but after I found out the error message "Automation Error, Catastrophic failure" and whenever I reset the VBE, I got an extra worksheet. So I can see from the project explorer that I have 48 sheets now!

Please, any idea to delete all those sheets and also solve my spreadsheets problems?

Thanks very much.

jJ

 

[Juan Pablo González]

After a PM (Please post questions here...), I found that this:

If IsError("optprice") Or IsError("stk") Or IsError("tme") Or IsError("r") Or IsError("exe") Then
Exit Function

shouldn't be like that. Remove the quotes:

If IsError(optprice) Or IsError(stk) Or IsError(tme) Or IsError(r) Or IsError(exe) Then
Exit Function