Skip to Content
avatar image
Former Member

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

Hello,

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Add comment
    10|10000 characters needed characters exceeded