Macro issue - Pop Up Boxes, Dialog windows

Help StudioX
,
1

In my bot, I am using a Run Spreadsheet Macro function. However, that macro that is being ran contains pop up boxes which then lead to a dialog window wanting a file selected to be imported. I have racked my brain for a while, and I can’t find a way to make this happen. I have included the pop up box and window below ( i used a blank folder for this for privacy concerns)…

A Microsoft Excel prompt is asking the user to select the 'Employee Data Labor History' file. (Captioned by AI)
A Microsoft Excel prompt is asking the user to select the 'Employee Data Labor History' file. (Captioned by AI)454×437 4.51 KB

A file explorer window is open, prompting the user to select an Excel file while displaying an empty "New folder" directory on the desktop. (Captioned by AI)
A file explorer window is open, prompting the user to select an Excel file while displaying an empty "New folder" directory on the desktop. (Captioned by AI)947×530 20.1 KB

Thanks for any assistance!

Steve

2

Hi @RPANovice1 ,

Could you let us know what you want the Macro to perform ?

Currently, it seems that the Macro asks for the User’s Input file to be selected to continue with its next steps.

Could you let us know more about what is that you are trying to perform with or without macro ?

3

@RPANovice1,

You can try Parallel activity with Isolation on.

4

Thank you for your response. I have never done Parallel with Isolation before, would you know where to find more information on that process for Studio X.

Thanks

5

That is correct, the macro shows a pop up box to indicate which file it wants to have selected.

6

@RPANovice1, Could you provide your view on the below mentioned query ?

7

The complete bot is running 4 reports from a web based application, saving these files, and then running a macro that will import these 4 files and then will use the data from these files to do multiple calculations.

8

Ohh ok. I don’t have StudioX handy right now but let me try and get back to you.

1 Like
9

@RPANovice1, I believe you would require the Macro to be modified to automatically include the 4 reports instead of asking the user for the file selection. If that is the case, could you share the Macro that is currently being used ? We could check for the modifications to be done and share the updated Macro with you.

Let us know if this is not what you wanted.