Adding values into Variable screen of Bex Analyzer

[#1]

Hi,

I am automating Opening a report through Bex analyzer using VBA macro.

I am facing issues while adding some values in the variable screen. In some blogs i had seen that this can be achieved by creating some range in the excel sheet

and calling this range through Bex built-in functions. Tried this approach but not able to as i am not aware of how to create a range.

Request you to let me know if any anyone has used VBA to add values in variable screen.

Thanks,

Farnaz

[RamanKorrapati]

Hi Farnaz,

Here you go,

How to set variables values via VBA.

http://scn.sap.com/thread/1306490

http://sap.ittoolbox.com/groups/technical-functional/sap-bw/select-bex-parameters-through-vba-excel-...

http://scn.sap.com/thread/1854040

http://scn.sap.com/thread/1853324

Hope it helps.

Regards

[Former Member]

Hi Chowthary,

Thanks for the information. The links shared by you are for BEX 3.5. Current version used in  my project is 7.2. Request you to let me know how to proceed with this.

Any idea on how to create a variant would be very helpful.

Thanks,

Farnaz