How to put Argument value into Excel Input box appear after executing Macro

Help Studio
1

I want to put the Argument Value into Input box appear after Macro Execution start. this Input box is the part if Macro coding.
Currently after macro execution start and Input box appear my Code gets stucked.

Below is my workflow screen shot where I mentioned if Element Exist (Input Box) but code is not moving there.

image
image887×372 20.7 KB

Below is the Input box appear in Excel Macro where I want to put my Argument value and then click on OK

image

Sample workflow has been uploaded for more reference.
Main.xaml (49.9 KB)

2

I would suggest that you put a log activity to see if the element is really detected by the element exists. And then you can just used send hotkeys to put the value if typeinto is not possible

3

Hi @nilesh.mahajan

The best practice is to create a new macro which with a parameter but need not input box,
and except for that it can achieve the same functionality as your original macro.

4

Hi, thnx for reply.
New Macro creation will not work because I used to download the macro from browser.

5

Hi, Thnx for response. I have used log activity. element exists is not executed due to input box appear in macro execution.

6

Hi Nilesh, you are able find solution for this?

7

Hi Sandhya,
Yes I have solution for this.

you can use Element exist activity and if the element esixt use Type into activity.

image

May be you can explain me your challange in more details, So that I can help.

8

This is how my workflow looks like:
1.Open a Micro Enabled Excel Spreeadsheet using ExcelScope Activity.
2.Execute Macro by giving the name.
Upon executing the macro, an input box will appear wherein i need to type in the username.

I tried using Type Activity to input the name but it doesn’t enter the username.
image
USername

9

Sandhya, you can find attached Sample solution. if you use Execute Macro acticity then you will not be able to type into Input Box. you have to use button in Macro file then click on that to execute macro and then you can type into Input box.

Input Box Trial.zip (78.6 KB)

let me know if any challange.
Mark as Solution if done.

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.