Sharing some useful macros
1. Full Path:
Purpose - Retrieve every file path for every tab and every file in a given folder, specified using the directory tool as seen.
Instruction - Connect the macro to the directory tool. Choose field: FullPath in the macro.
2. Multiple sheets input:
Purpose - This input will open the file by converting the file path. Useful if you wish to open multiple sheets in one input by only using one input tool.
Instruction - Use the List of Sheet names input method in the input tool. Or use the above full path macro to retrieve all file paths. Use the formula tool to add the sheet name to the filepath. Add the macro and Choose field: FileName.
3. Multiple sheets input (any):
Purpose - For many inputs which are similar in nature and you need them combined using union in one input.
Instruction - Save them all in one location and use the Full Path macro (see above) to retrieve all the filepaths. Select this file path field in the macro to open and union all inputs together into one sheet.
4. Remove BAK files:
Purpose - Removes all BAK files created in the specified folder location.
Instruction - Add a control container around your output. Add the BAK macro to the workflow and add a control container around it. Connect the control containers so the BAK macro will be performed after the output tool is ran. Use the formula tool to create the folder path of the output file. Select this field in the BAK macro.
