Putting Data into a Macro Excel File

MOlinski

Hello,

I have attached my output for my Ateryx workflow (JE TEST). I am looking to have Alteryx add this to a Macro Excel file that I have. What I would like is to grab everything from row 2 and down, and paste it into my JE Template Test excel file, starting on line 13. Unfortunately, I am unable to attach a macro file, so I have disabled the macro on the JE Template Test file. Is this possible to do?

Thank you,

JE TEST.xlsx

JE Template Test.xlsx

rfoster7

You can specify the output range in your template xlsm file to overwrite and you can Skip field names: 

That should be sufficient for your needs. I am using an arbitrarily large end row number in the range so that your always overwrite the data from prior runs even if they had more rows than your current run. If It was me, I'd make sure my base template file was empty and then use a rowcount to create the corrent range in my output. But this should suffice for your needs.