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
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