This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!