How to pass a variable to an "Invoke VBA" script?

[Stanciu_Nicu]

Hi all,

I found on the forum a VB script that helps Clear entire excel sheet cells, using some VBA:

Sub clearEntireSheet()
Sheets(“Sheet1”).Cells.Clear
End Sub

However, this script will only clear values in a sheet called “Sheet1”.

Question: how can I make “Sheet1” dynamic, and pass any string variable from my project to this VB script, so that it can clear any sheet name I provide to it?

Many thanks,
Nicu

[ermanoj3101 (MANOJ)]

Hi @Stanciu_Nicu ,

You can pass any argument like this.

[Catalina_Rs (Catalina)]

Hi @Stanciu_Nicu,
You can use the scrpit modified like this

Sub clearEntireSheet(SheetName as String)
Sheets(SheetName).Cells.Clear
End Sub

In workflow use Invoke VBA activity where in EntryMethodName you have to use VBA’s name and in the Parameters you can pass the sheet name you want.

[jack.chan]

change the vba code to this

Sub clearEntireSheet(sheetName As String)
Sheets(sheetName).Cells.Clear
End Sub

Then in uipath:
use invoke vba activity, under EntryMethodParameters pass in the sheet name you want to delete e.g. “Sheet5”

[Stanciu_Nicu]

Thank you all for quick and valuable input. Marking @jack.chan’s answer as the most complete one. It works!