Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Putting Data into a Macro Excel File

MOlinski
7 - Meteor

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,

1 REPLY 1
rfoster7
9 - Comet

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

 

image.png

 

 

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. 

Labels