Hi fellow Alteryxers,
I got myself into somewhat of a conundrum, regarding which I seek your wisdom.
I have been developing a relatively complex macro that produces a number of summary tables, which in the end if the user chooses to do so would export said tables formatted in an .xlsx. The formatting bit and the .xlsx format are really important and so the output tool does not work. Hence, I have been trying to use the Render tool.
Conceptually the end part of the workflow relevant to the question looks like this: Produce a data summary -> Use table tool to format the summary -> Use union tool to bring together all the different formatted tables -> use layout tool to prettify final output -> use render tool to export in .xlsx. Then I connected a Folder Browse tool to the Render tool allow the user to specify the location of the export and also the file name and format, e.g. ...\Exposure Exhibits Macros\Exposure Total Tables - Reporting 1.xlsx.
When I have the macro open and run the macro workflow it does export the files really nicely, however when I use it as a macro in a workflow and specify the export location, file name and type, the macro runs but doesn't create any files.
What am I doing wrong?
Thanks for your help in advance!
