My Excel/PowerPoint reports are not working. How can I fix it?

If your security settings in MS Office are set too high, the macros used to generate the reports may not run. You can solve this problem by setting the security settings to low (in the Tools/Macros menu in older versions or Trust Center settings in newer versions). 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 higher.

To create a security certificate to make this a trusted document 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" or "Error 1004 - Programmatic access to the Visual Basic Project is not trusted", 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. To access this setting:

  1. Open Excel
  2. From the File menu/Office button, select Options
  3. Select the Trust Center category
  4. Click the Trust Center Settings button in the lower right
  5. Select the Macro Settings category
  6. Check the box marked “Trust access to the VBA project object model”

In order to run reports in FormingSuite version 2017.0 or newer, you also require Microsoft's XML library. This should be installed by default on most systems, but you can install it manually by downloading it from Microsoft's web site.

If you are getting ActiveX related errors (like error 429), there is likely an installation issue with FormingSuite. One of the following solutions should resolve this issue:

  1. Try re-installing FormingSuite as Administrator (right click on the installer and select 'Run as Administrator'.
  2. Open a Command Prompt window (Start/Accessories/Command Prompt) as administrator, switch to the root folder (cd\) and type C:\FTI\FormingSuite\regtlibv12 "C:\FTI\FormingSuite\FS.tlb".
    If you are using FormingSuite 2013 or newer, do this for FS32.tlb, FS64.tlb, FSTags32.tlb, FSTags64.tlb, FSConsts32.tlb and FSConsts64.tlb. This will register the type libraries that enable Excel to communicate with FormingSuite. Finally, register the FormingSuite executable by typing C:\FTI\FormingSuite\FS.exe /register
  3. An alternate solution is to run the software as administrator and create an excel report once (right click on the FormingSuite icon and select 'Run as Administrator'). This should automatically register the files required for user accounts to create reports.

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

Powerpoint 2013 and 2016 will show the start screen after generating the report. Pressing the escape key will take you to the report, or you can select the report file name from the top of the recent file list to show the report. If powerpoint generates two documents and an error message is produced when a report is run, go into the Trust Center settings and uncheck the check boxes on the Protected View page.

harley Johnson_Controls Freightliner_Trucks l_bmw l_nissan l_chrysler l_ford l_mercedes l_VW volvo2