Batch Macro Not Outputing to XLSM

Question

I have a batch macro that I am wanting to write in to my workflow that will loop through a specific site listing, update a filter within the macro, and then should output the data on to a table/range within an .xlsm file.

Configuration of XLSM (output tool)

Configuration of batch macro

Ideally, the output should look something like this:

But instead it looks like this:

The batch macro loops through each file successfully, but it looks like it is not overlaying the data on to the xlsm before creating the output. Any help would be greatly appreciated!  😀

Luke_C · Answer

Hi @ridodson

By changing the file name you are creating a brand new file with no formatting to keep. It sounds like what you need is a template file with your formatting that can be used to output any number of files for each site. Here's two approaches:

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Clearing-Data-in-Template-before-Overwrite/td-p/738441

ridodson · Answer

Thanks for reaching out, @IraWatt!

What I would like for the workflow to do is take the data that is filtered out through the batch macro, and then essentially copy/paste (for lack of better terms) it in to the xlsm, then save the xlsm as a specific file name. Each site will have its own file they will be working off of.

I have attached the original workflow that I am building. For ease, it will be the last sub-container on the upper right-hand side. It is entitled "SITE ITERATION MACRO".

Edit: Attached picture of container that I am referring to.

TOM BLUEPRINT - DODSON.yxzp

IraWatt · Answer

Hey @ridodson,

By overlay do you mean its not applying the formatting? You can preserve formatting by ticking here:

Or is it the headers your wanting?

Could you provide a sample workflow?

Thanks,

Ira