Skip to Content

Excel VBA with Analysis - setting the date fields (from and to)

Feb 07, 2017 at 03:50 PM


avatar image
Former Member


Usually in the prompt, under Fiscal Year/Period there's a 'from' and 'to' fields.

May I ask how do I go about inserting it via Excel VBA?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 08, 2017 at 09:20 PM

I am afraid you won't be able to. This is a WPF dialog, not a workbook object. Analysis does not offer API for you to interact with its form object like this.

What you may consider doing, is to build/update the BEx queries (assuming you are using Analysis to report on BEx queries) with the default value filled in for the parameters. But this is not a resolution to your requirement.

Another option is to use some screen automation tool (I don't have any to recommend though), to capture and input values to the form object. It's also not an elegant solution. Well, good luck.

10 |10000 characters needed characters left characters exceeded