How to create custom activity using VBA macro based code

[Vikram212 (Vikky)]

Hi,
i hardly know vb.net but i know Excel macro so i wanted to create custom activity using VBA macro

Is it possible, how can i do that ?

[Palaniyappan (Forum Leader)]

we can use INVOKE VBA with your vb.net script
–first write a txt file with your vb net script
–use INVOKE VBA activity and pass the file path of that text file as input
https://docs.uipath.com/activities/docs/invoke-vba

Cheers @Vikram212

[Vikram212 (Vikky)]

Thanks but i dont want to use invoke VBA activity because it gives Trust access error and user has to do that manually and also it might have loads of parameters to be passed in entry method parameter.

so only trying to create activity which will ease

[Palaniyappan (Forum Leader)]

Fine
here you go with a document from uipath

Creating a Custom Activity

Cheers @Vikram212

[allurai_india ((Allu)Alluraiah Yallapragada)]

hi

do you like to run a Macro in MS-excel file ?

[Vikram212 (Vikky)]

yes @allurai_india

[allurai_india ((Allu)Alluraiah Yallapragada)]

Hi

1)Take the activity “Excel applicatoin Scope”
Mention the path of macro file …xlsm
2)Please take help of “excecute Macro” Activity.

Propeties :

input

MacroName: "mainframe_Validation1

following should be your VBA code in excel file

sub mainframe_Validation1()

end sub