Question Re: Multiple variables selection - Macro in Technology Q&A

Multiple variables selection - Macro

former_member985103 — Wed, 13 Jul 2022 13:22:04 GMT

Hi,

is it possible to select two variables (US and DE) with the below code? How should it be adjusted?

Call Application.Run("SAPSetRefreshBehaviour", "Off")

Call Application.Run("SAPExecuteCommand", "PauseVariableSubmit", "On")

Call Application.Run("SAPSetVariable", "0BWVC_COUNTRY", "US")

Call Application.Run("SAPSetVariable", "0BWVC_COUNTRY", "DE")

Call Application.Run("SAPExecuteCommand", "PauseVariableSubmit", "Off")

Call Application.Run("SAPSetRefreshBehaviour", "On")

Thanks!

Re: Multiple variables selection - Macro

Former Member — Wed, 13 Jul 2022 13:22:18 GMT

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

* Use the "insert code" feature when sharing your code, so members have an easier time reading.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Re: Multiple variables selection - Macro

MKreitlein — Wed, 13 Jul 2022 13:44:51 GMT

Hello Gasper,

it should work like:

Call Application.Run("SAPSetVariable", "0BWVC_COUNTRY", "US;DE")

BR,

Martin

Re: Multiple variables selection - Macro

former_member985103 — Wed, 13 Jul 2022 14:33:21 GMT

Hi Martin!

Thank you! This works 🙂
Do you maybe have a solution also for the below code? I would like to use dynamic variables (Datex1 and Datex2) instead of fixed variables (in " "). Please see my code below.

Sub UpdateData()

Dim Datex As String
Worksheets("Sheet1").Select
Datex1 = Range("G2").Text
Datex2 = Range("E2").Text

SetReportingUnit = Application.Run("SAPSetVariable", "Select FCRSCode-Child(s) Opt", Datex2;Datex3, "INPUT_STRING", "DS_1")

Re: Multiple variables selection - Macro

MKreitlein — Thu, 14 Jul 2022 05:34:46 GMT

Hello Gasper,

for the 2nd example you probably need to concat the texts into one Variable:

Datex = Datex1 & ";" & Datex2

And then use this one:

SetReportingUnit = Application.Run("SAPSetVariable", "Select FCRSCode-Child(s) Opt", Datex, "INPUT_STRING", "DS_1")

Re: Multiple variables selection - Macro

former_member985103 — Thu, 14 Jul 2022 12:40:03 GMT

Hi Martin,

this is exactly what I was looking for 🙂

Thank you so much!!