I tried to import a macro from excel in the project to add filters to my columns, but it gives me this error:
I mention that i checked the
Trust access to the VBA project object model, under Macro Settings in Options.
Please help me
. Thank you!
@CristinaAlina have a Look in this
Do these steps to avoid that
Open a blank workbook in Excel.
Go to File > Options > Trust Center
Click on Trust Center Settings…
Under Macro Settings , make sure Trust access to the VBA project object model is checked.
Then Focus on the settings from the Excel Activity e.g Excel Application scope Macros enablement
If this setting is enabled that would work for sure
Kindly restart once the uipath studio and excel application as well and try once
Open a blank workbook on MS Excel
Got to File >> Options
Click on Trust Center >> Trust Center Settings
Click on Macro Settings >> Check ‘Trust Access to the VBA project object model’ (under Developer Macro Settings)
Ok…i restart the laptop to be sure… and it doesn’t give me that error anymore, but it gives me another one:
What am i doing wrong?
Kindly have a view in this thread
I cant enable it manually. Access issue.
Make sure that the invoke VBA is kept inside a excel application scope and and file is with extension xlsm
@Palaniyappan but i discovered what was the problem. The name of method in my invoke VBA it wasn’t corresponding to the name of Macro that i created , and the command for selecting the cells in Macro it wasn’t correct.
I made the corrections in the Macro, and to the activity as well and it worked
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.