Generating Excel Reports in Chemoview 2.0.2 Fails With Message Programmatic Access to Visual Basic Project is not trusted

For research use only. Not for use in diagnostic procedures.

Issue Description 

When creating excel reports using Chemoview 2.0.2 the report creation will fail and the message ‘Programmatic Access to Visual Basic Project is not trusted’ will be displayed in the report preview.

 Resolution

Access must be granted to the Visual Basic Project Object Model in excel following the procedure (shown with en-US Office 2010 but process the same for 2007):

1. Open Excel And Click ‘File’ Then ‘Options’

2. Select Trust Center and then Trust Center Settings….

3. ‘Click Macro Settings’ and then check the ‘Trust access to the VBA project object model’ check box.

Press OK, OK, and then close Excel. Chemoview should now create reports correctly.

RUO-MKT-18-3075-A