Excel Macro Code issue

[JITU99 (jitendra)]

Hi All,

This is a part of my excel macro where it opens a text files from mentioned path.I want to pass the directory path where the file is present from a paramter through the execute macro activity.Can you please help the changes i have to do in this macro?
The highlighted part should come through as paramter from Macro Activity.
Thanks

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @JITU99 ,

Use execute macro activity in UiPath and it is having option that we can pass parameter. In our case we have to pass file path as parameter.

For this you have to modify your code little adding Filepath As string in your macro function and replace this Filepath to your hardcode file path in your macro code.

Please review the below thread it is having detailed steps on how to pass parameter to macro and how to modify our macro code. I hope it will helpful to your requirement. Thanks.

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…

[JITU99 (jitendra)]

Hi @kirankumar.mahanthi1 Thanks for your reply my issue here is how to implement that macro code and i tried some methods but it is failing not sure about the syntax to follow.(i had gone through the process already)

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Could you share your requirement and what you are trying to achieve with macro code. I suggest we should go for vb code so that we can handle it in invoke code activity and we don’t need to use execute macro. Thanks.

[JITU99 (jitendra)]

It’s simple i have to use a variable as you said in the attached vba code(screenshot is in thread).But dont know how to implement it.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Did you tried like below. thanks.

Sub Formatting(FilePath As String)

With ActiveSheet.QueryTables.Add(Connection:=“TEXT;” + FilePath, Destination:=Range(“$A$1”))

[JITU99 (jitendra)]

Hey Kiran It worked Thanks for helping out.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

i could see that you marked solution for your last message. if possible Could you pls mark my suggestion as solution for your issue if you think it helped you to resolve the issue. thanks.

[JITU99 (jitendra)]

I had correctly marked now Thanks!

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Thanks buddy. Your welcome. it is nice connecting with you.