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

Help Studio
1

image
image872×238 12.5 KB

2

Hi @Aparna_Reddy1

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

image

image
image1012×840 16.8 KB

image
image741×332 11.8 KB

Enable all macros

Regards

4

can you please tell me

5

yes i got it tq

6

Hi @Aparna_Reddy1

You need to go to the excel options!

Regards

7

image
image854×141 8.5 KB

after enable … now am getting this.

8

can you please give me solution

9

give me solution

10

Hi @Aparna_Reddy1

Try giving the full path!

Regards

11

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

12

Hi @Aparna_Reddy1

Try changing the extension to .txt instead of vbs

And have a look on the documentation below!

Regards

13

image
image854×180 12 KB

now its showing like this

14

can you please give me solution

15

y am getting this error

16

@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

17

@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

18

Hi @Aparna_Reddy1

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

image
image807×502 13.9 KB

Check with zip file below!

VBA_Processs.zip (8.2 KB)

Regards