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

[former_member182470]

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