Excel - Programmatic access to Visual Basic Project is not trusted Exception

Hi @Aparna_Reddy1

You need to enable the macro settings from the excel settings from the excel application!

Enable all macros

Regards

can you please tell me

yes i got it tq

Hi @Aparna_Reddy1

You need to go to the excel options!

Regards


after enable … now am getting this.

can you please give me solution

give me solution

Hi @Aparna_Reddy1

Try giving the full path!

Regards

i given full path but still showing same …like file not found

Hi @Aparna_Reddy1

Try changing the extension to .txt instead of vbs

And have a look on the documentation below!

https://docs.uipath.com/activities/docs/invoke-vba

Regards


now its showing like this

can you please give me solution

y am getting this error

@Aparna_Reddy1

Have you tried the as like the eg mentioned in above document!

Have a look on. It

InvokeVBA Example.zip (14.7 KB)

Regards

@Aparna_Reddy1

Is the same macro name given as per in the code

In the second tab in the activity check with that also!

Regards

Hi @Aparna_Reddy1

Have you checked the enable macro and trust to vba project in excel!

Check with zip file below!

VBA_Processs.zip (8.2 KB)

Regards