Showing results for 
Search instead for 
Did you mean: 

Change Master Data Attribute Value (VBA sample) - Object doesn't support this property or method

Active Participant
0 Kudos

We are trying to implement integrated-business-planning-excel-addin-vba-samples/VBA samples/Samples for SAP IBP APIs released w... which tries to allow the change of attribute's value via custom (sample) VBA on the planning view.

In the sample code from SAP, the ABC code is the attribute to be changed:

The documentation says:

Why do they use "4" here in the sample code? I would assume that it needs to be shifted to the right "2" columns instead, to find a data point (Key Figure?).

When trying to test this. It seems to be the case. For example if I want to change the Unit of Measurement, you can see that in this view, to go from a Unit of Measurement (Attribute) to the Year period (Key Figure), we need to shift one column to the right:

Indeed, instead of giving the error "Select cells within the data area of the planning view"

when adapting the code and using ...(Target.Offset(0,1)) the code allows to ask for a new input:

However, when trying to proceed in the "Change UOM" view, to actually change the Unit of Measurement from "PC" into "A" for example (so after pressing OK), the following error appears:

"Object doesn't support this property or method".

Why would this error occur, how to prevent this error and make the code operational please?

Accepted Solutions (0)

Answers (0)