Problem in running a macro from VB6

[Naga]

When an excel application containing macro is called from the VB6, the excel
application is giving the error 'Programmatic access to visual basic is not
trusted'. I am not getting this error when using excel 2000 but when using
office xp I am getting the above mentioned error. I checked in some forums
they have given the suggestion to check the 'Trust access to visual basic
project' when running the macro. Is it possible to do it programmatically. I
want to create an report in excel and save it from VB6 without any
warning/error messages inbetween. Please let me know the possible solution.

 

[Dave Peterson]

This is a security setting that the user controls. If your program could do
this, then it really wouldn't be much of a security measure.