Hello,
I have a macro that reads in data from an Excel sheet, re-organizes it, and then writes it to a different tab on the same workbook. We use a macro because we have the same template for several of our locations. The problem that I am running into is that for most locations, the macro works as expected, but for a few of them, the file appears to be corrupted after we run the workflow. When I try to open those few files, Excel gives me the following error message after it has finished recovering the file:
"The name in the end tag of the element must match the element type in the start tag"
I have tried to compare everything I can between the files that the macro does work for, and the once for which it does not, and I cannot find any difference. I am very confused why it works perfectly fine with some of the Excel files, but not others given that they are all nearly identical (only different file name and data, but same structure and format).
I have narrowed the issue down to a particular output tool. Here is how I have it formatted:
For reference, I am using Alteryx Version: 2024.1.1.136 Patch: 4
Any help is greatly appreciated. I have been working on this issue most of the day and still have no Idea why it works for some files but not others.
Thank you!!
