BUG: Unhandled exception error when importing macro

I am trying to build a workflow that uses a batch macro to:

- Read in the list of sheet names from an Excel file (each sheet has a different schema)

- Create the required Excel sheet paths

- Send the list of Excel sheet Paths to the batch macro

- Batch macro feeds an input tool (directly with sheet path) and an output tool (with a regex formula that changes Workbook.xlsx|'Sheet1$' into Workbook_Sheet1.csv)

However I am getting an unhandled exception error when I try to import the batch macro into the main workflow.

Any ideas?

Process multiple sheets.yxmd

Process single sheet.yxmc

Workflow

Macros

Accepted answers

NeilR

Hi acowper,

I was able to replicate your issue. I fixed it by removing the carrot characters from the Output tool file path (see attached). Nevertheless the unhandled exception error is a bug that I will report to our product team.