[Help Needed] Cannot Run VBA Macro via Invoke VBA — “Trust Access to VBA Project Object Model” Already Enabled

Help StudioX
, , ,
3

Hi @nashwasabila11

Can you try using classic activities.

This is just an example of flow:

The image depicts a workflow diagram for an automated macro process where a list of inputs is initialized and appended, a macro utility workbook is opened and read, a macro function is executed to get output, and then the workbook is closed to prevent further locks. (Captioned by AI)
The image depicts a workflow diagram for an automated macro process where a list of inputs is initialized and appended, a macro utility workbook is opened and read, a macro function is executed to get output, and then the workbook is closed to prevent further locks. (Captioned by AI)524×840 35.8 KB

Inside Append Items in Collections pass the necessary values which you are using in the Macro.

Hope it helps!!