How to use Excute macro Access with parameteres?

[CAE_User]

How to use Excute macro Access with parameteres ?

[Palaniyappan (Palaniyappan P)]

No worries
Hope this would help you resolve this

Passing Argument to Excel Macro

I’m also trying to use Execute Macro Activity and trying to pass parameter of DateTime type. How do U achive that?

How to execute Macro with arguments

I looked at it and seems some of the Excel features are not working correctly. .Copy and .Select for example are not working. However, .Value is working. So this is strange. If I find a workaround for this I will let you know. Here is a snippet of one of my .vbs files on a part that creates an Excel object then creates a new workbook [image] As you can see it’s similar to VBA but with a few differences to some syntax; one key difference is you can declare variables in one line. Also, I wo…

Cheers @CAE_User

[Naveen.Ch (NaWin)]

hi @CAE_User

we have to pass method name what we have written in excel file .xlsm and it will execute end to end

[Palaniyappan (Palaniyappan P)]

did that work buddy
Kindly let know for any queries or clarification
Cheers @CAE_User

[laurence.bellingham]

I also couldn’t pass 2 or more arguments into a macro successfully. What did seem to work is passing in 1 argument that is a list object. If I have for instance 3 items in the list object then the vba function should have 3 arguments. They are allocated in sequence so argument 1 in VBA is the first item added to the object list via the add to collection activity in Uipath.