If you call Analysis function “SAPGetProperty” with any of the documented parameters (except “LastError”), while there aren’t any Workbooks open, Analysis encounters an unhandled exception. It doesn’t seem to matter if you provide any additional parameters, Analysis still crashes.
Nested exception. See inner exception below for more details:
Object reference not set to an instance of an object.
It’s easy to test if the workbook count is greater than 0, in VBA, before calling this function, but it would be nice if the exception was handled by Analysis without crashing or requiring a restart.
I’ve experienced this behaviour with Analysis SP4.1 and Excel 2007. You may experience different behaviour with other Analysis/Office versions.