Send path from UIPath to macro

[fairymemay (noona)]

I have variable path(string) = “C:\Users\Titi\Desktop\input\ “+month+”_”+year+“.xlsx”

I want to send path to macro for open file instead of in path square red as below.

Please guide me.

[prasath_S]

Hi @fairymemay

Please refresh to the below post

Execute Macro and Pass Parameter - Solution

Hi All, Here are the steps to use Execute macro with parameter I wish to add a number with macro code contains numbers. Process Step: [image] step 1: creates a macro file with the below code. [image] Step 2: Use input Dialogue box to enter your number and create var B to store it. [image] [image] Step 3: use Execute macro activity and provide the macro name into an activity box. Then in the property panel on the macro parameters tab pass your arguments like below. [imag…

[fairymemay (noona)]

@prasath_S Year and month are not pass to macro as below.

My variable as below.
month = Date.Now.AddDays(-3).ToString(“MMMM”)
year = Date.Now.AddDays(-3).ToString(“yyyy”)

[Kah_Liang (Kah Liang Loh)]

@fairymemay
Maybe something wrong with path.

You can try to first assign a variable = month + “_” + year + “.xlsx” as let’s say “ExcelPath”

Then pass it into the path.

Regards,
Kah Liang

[prasath_S]

@fairymemay first check if the file is present using path exists activity.

Or first send the file path as hard-coded and not on the variable

[fairymemay (noona)]

send the file path as hard-coded // work completed not error.

[fairymemay (noona)]

@Kah_Liang Same error.
month and year not send value to macro.

[ptrobot]

From your screenshot it looks like the variables month and year are empty. Have you checked that the path variable looks correct before sending it to the macro? (You can use Write Line to print the variable value to the Output panel to check.)

[fairymemay (noona)]

@ptrobot It show value correct.

[ptrobot]

Thanks! And how does path look?

[prasath_S]

could you please put path variable in the message box and send what the path looks like

[fairymemay (noona)]

@ptrobot @prasath_S message box path not show month and year.

[prasath_S]

@fairymemay show the syntax where you are appending both the path ,month and year.

[ptrobot]

When do you assign the month and year? It should be before the path assignment.

month = Date.Now.AddDays(-3).ToString(“MMMM”)
year = Date.Now.AddDays(-3).ToString(“yyyy”)
path = "C:\Users\Titi\Desktop\input\"+month+"_"+year+".xlsx"

Or could you share your workflow so we can help you troubleshoot?

[Pravin_Patil1 (Pravin Patil)]

@fairymemay

Your code should be like below

Sub B**(filePath As String)**

Apllication.WindowState = xNormal
Workbook.Open Filename = filePath
Range(“A1:A10”).Select

End Sub

You missed passing the parameter to your method… Also, create the same variable name(filePath) of type string in the studio from where you are passing the path to execute macro activity…