1

I am updating a data source from an Excel macro by running this:

Application.Run("SAPExecuteCommand", "RefreshData", "DS_1")

That generates a prompt asking for the user to input query parameters. However, I just want to go with the already set parameters. Is there a way to suppress the prompt altogether or perhaps effectively just click OK when prompted? (perhaps finding the element that is the OK button and clicking it from the same macro, without resorting to absolute coordinates?)

The prompt that I want to suppress or obviate:

The prompt that I want to suppress or obviate

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
soft_weaver
  • 23
  • 2

1 Answers1

1

I believe you should pre-populate some of the fields and save the file. Some of the fields are mandatory, and maybe you have not filled them all out in the file you are loading and refreshing.

I am using Call Application.Run("SAPExecuteCommand", "RefreshData") similarly, and I do not get a dialog box.

You could also try to set variables and then execute a refresh from within VBA using

Call Application.Run("SAPSetVariable", "my_variable", value, "INPUT_STRING", "DS_1") 
Call Application.Run("SAPExecuteCommand", "RefreshData")
divingTobi
  • 2,044
  • 10
  • 25