use R's openxlsx to add a worksheet to an existing Excel file with a macro .xlsm

it is possible to use R’s openxlsx to add sheets from within KNIME to an existing Excel file which contains Macros..
With newer Excel Writers this can be done without R.

External resources

• original discussion
• Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
• R - openxlsx: Read, Write and Edit xlsx Files
• MEDIUM: KNIME and R — installation across operating systems — some remarks
• HUB: use R's openxlsx to add a worksheet to an existing Excel file with a macro .xlsm