Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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.

Labels in this area