3.2.7 VBA-macro-enabled format .XLSM

By default, a resultant form file will be composed with .XLSX format, which does not approve embed VBA-macro.

However, if You need to embd Your own VBA-macro, You should to change file format from .XLSX to .XLSM , which supports VBA-macro.

To do it:

  • Select Root node in the form structure tree

  • In the Properties tab, in the item «File format» press button "Edit" and choose required format:

If one of Your own embed VBA-macro need to be automatically run directly after file creation (once), just pass required macro name as IMPORTING-parameter IV_STARTUP_MACRO when F.M. ZXLWB_CALLFORM is calling.

For example:

IV_STARTUP_MACRO = 'Module1.Macro1'

Note:

VBA-macro can only be run in dialogue runtime mode, and it will be ignored in background processing.