This macro allows users to easily output their workflow to multiple Excel files or sheets, removing the need for creating a custom file path each time either of these options are required.
The configuration is very intuitive and allows the user to:
- Select a target directory
- Choose whether they want multiple files or sheets
- Input a filename if multiple sheets is selected
- Nominate a 'grouping' field which the data set will be split on
As an addition, the macro also removes 'illegal' characters that cause issues when saving .xlsx files, such as #!%.
This is a fairly basic macro built to service a request I noticed coming up very frequently within the Designer discussion forum. In the future I will look to add more functionality. Any feedback/criticism/requests are very much welcomed!
