Using File Explorer in Excel Macro

Help Studio
, ,
1

I have a spreadsheet I need to automate that contains a macro that opens file explorer intended to load in a CSV containing data to populate a pivot table. When I use the execute macro activity it opens the file browser but gets stuck in the activity as the macro has not fully executed. I have tried adding the filepath into the macro parameters however I get the error ‘Execute Macro: Number of parameters specified does not match the expected number.’

Is there any way I can stop the execute macro activity hanging? I could use ui automation on the excel file however ideally I want to avoid this.

Thanks all.

2

If you are adding parameter in your procedures in VBA then add parameter in Execute Macro activity as well and vice-versa. I believe are missing to add parameter in one of the place.