January 23, 2020, 1:33pm
Test.zip (27.1 KB)
I am trying to run a VBA macro from Studio but it always fails saying permission denied.
I have already set the trust centre settings to 'Trust access to VBA object model
The macro itself just brings up a message box (as it’s just a test). But when I run the Uipath process I get a permission denied error.
Does anyone have an idea what is going on here please?
I’ve attached the spreadsheet and the very simple workflow.
There is also something a bit weird going on where if I stop the process (in debug mode when the error is first generated) and then shut down the excel, a ghost excel process is left running which I can shut down manually (with task manager) but the kill process activity doesn’t seem to have any effect at shutting this down (I don’t think this is related as I kill the excel manually prior to running the process)
Many thanks in advance,
January 23, 2020, 1:46pm
Try the following things,
If you already have that checked in that particular excel, then try to restart your machine once , that will do the trick as it worked for me
@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
January 23, 2020, 11:44pm
@rmunro thanks very much for the reply but I need to be able to run a macro embedded in a workbook rather than a vba script run from a text file.
Thanks for the example anyway.
All the best,
January 23, 2020, 11:52pm
I’m such an idiot I should have been using the execute macro activity! Don’t worry I am currently banging my head against wall to help knowledge sink in.
January 26, 2020, 11:52pm
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.