Conversion: Disable Visual Basic macro errors despite of disabled macrosPermanent link for this heading

Last update: 17 February 2021 (cf)

InformationPermanent link for this heading

For security reasons, on all conversion servers, the macro execution of Microsoft Office applications should be disabled. Fabasoft Conversion services also include a logic to automatically close opening dialogs that are shown by Microsoft Word and other Microsoft Office applications, to skip and proceed the conversion.

From a customer, Fabasoft got knowledge of a special warning dialog shown by Microsoft Visual Basic (VBA), that is displayed even though macro notification is disabled in Microsoft Word. Furthermore, the Fabasoft Conversion service cannot access and close this dialog because of Windows security mechanisms.

SolutionPermanent link for this heading

SummaryPermanent link for this heading

The following steps show how to change the TEMP directory of the Fabasoft Conversion services, disable macros in Microsoft Word, and add the new location to the trusted locations of Microsoft Word.

For more information about trusted locations in Microsoft Word, see Microsoft Knowledgebase https://support.microsoft.com/en-us/office/add-remove-or-change-a-trusted-location-7ee1cdc2-483e-4cbb-bcb3-4e7c67147fb4

All steps need to be done on the conversion server (or all conversion servers) and with the conversion service user logged in to Windows .

Change temporary directory of Fabasoft Conversion servicePermanent link for this heading

By default, the TEMP directory of Fabasoft Folio Kernel is located in the %TEMP%\Fabasoft directory of the Conversion service Windows user.

For the change of the trusted locations of Microsoft Word, it is required to change the location of this directory, as Microsoft Word implicitly does not allow the %TEMP% directory as a trusted location.

  • Create a new folder for Fabasoft temporary files, e.g. C:\FOLIOTEMP, with permissions for the Folio Conversion service user.
  • Change Fabasofts *.upd files:
  • In Windows Explorer, navigate to C:\ProgramData\Fabasoft
  • Edit both files, coomk.udp and cooprep.upd:
  • Add a line (or change, if already exists):
    HKEY_ENVIRONMENT\TEMPDIR=C:\FOLIOTEMP
    or with the path of your new directory

Add a line (or change, if already exists):
HKEY_ENVIRONMENT\DOCDIR=C:\FOLIOTEMP
or with the path of your new directory

  • Save both files and restart the Conversion service.

For further information about Fabasoft Folio Environment Variables, check our documentation:
https://help.folio.fabasoft.com/index.php?topic=doc/Fabasoft-Folio-Envir...

Micrcsoft Word: Disable macro executionPermanent link for this heading

For security reasons, you always should keep macro execution disabled on all Conversion servers.

  • Still with the Conversion service user logged in, start Microsoft Word
  • Navigate to File / Options
  • In the Options window, select Trust Center and Trust Center Settings...
  • In the Macro Settings, select Disable all macros without notification .

Microsoft Word: Add trusted locationPermanent link for this heading

The dialog from VBA does not appear, when the file is opened from a trusted location. Therefore, we add the new folder C:\FOLIOTEMP to Word's trusted locations:

  • In the already opened Trust Center , navigate to Trusted locations .
  • Press the button Add new location... and navigate to the new folder C:\FOLIOTEMP
  • Also activate the checkbox Subfolders of this location are also trusted
  • Save the settings

If you still have issues, please contact Fabasoft Support.

Download PDF

Download PDF