My Excel report is not working. How can I fix it?

If your security settings in MS Excel are set too high, the macros used to generate the Excel report may not run. You can solve this problem by setting the security settings to low (in the Tools/Macros menu). If your corporate security policy does not permit the above solution, you can also create a security certificate that will permit the FormingSuite® report macro to run even when the security is set to high. To create a security certificate do the following:

1. From the Windows Programs menu, choose Microsoft Office -> Microsoft Office Tools -> Digital Certificate for VBA Projects. In the Create Digital Certificate dialog type the name you want to display (i.e. “Forming Technologies Inc.”), and click OK. From within Excel, open the Visual Basic Editor (using the tool/macros menu). Choose Tools -> Digital Signature. In the Digital Signature dialog, click Choose. In the Select Certificate dialog, select the certificate to use (created in step 2), and click OK. Click OK again to close the Digital Signature dialog.
2. Save and Close a workbook.

Once the code is signed, you may see a Security Warning when you open a workbook again. -> Select the option “Always trust macros from this publisher” and click Enable Macros.

Now you won’t see the warning every time you open a workbook that is signed.

If you get an error that says "Programmatic access to Office VBA project is denied" open the Trust Center in Excel and go to the Macro Settings section. Make sure the "Trust access to the VBA project object model" check box is checked. Close Excel and try making the report again.

If you are getting ActiveX related errors, this is likely an install issue with FormingSuite. Try re-installing FormingSuite as Administrator and reboot the system before continuing.

If the above does not work, open a Command Prompt window (Start/Run/cmd.exe), switch to the FormingSuite folder (cd \FTI\FormingSuite) and type regtlibv12 FS.tlb. This will register the type library that enables Excel to communicate with FormingSuite.

Note that the report may fail if Excel is already open or if there are more than one instances of FormingSuite running on the machine.