VBA macro outputted in an external file

[Denisa_Grecu]

I have the following situation:

Context:

1. I created a project for one of our teams based on a manual reconciliation previously existing. The initial manual recon had a VBA macro that, once the team finished the reconciliation, would update the data within our company´s system.

Due to the database inconsistency, the reconciliation wasn´t automated 100%, therefore, once having first output, the team has to modify the file with additional information. Afterwards, this information should be updated in our system Vermeer. 

2. What I need to achieve is to take a macro from the initial excel file though Alteryx and output it as a macro in the Excel output file in order the team to be able to run the macro by themselves after the latest changes applied to the file created by Alteryx. 

From what I have read from the Alteryx community, Alteryx is able to run just formatting macros (for a better arranging view of a report, for e.g.) through a script or an event created directly in Alteryx and will output directly just the result. In my situation, would be possible to bring within Alteryx an already existing VBA excel macro and output it as a macro in order to be run when needed (outside Alteryx)? 

[Robin_McIntosh · Accepted solution]

@Denisa_Grecu - If I'm following you correctly, why don't you have a blank file (.xlsm) with your macro, then copy that file via Run Command tool and then output your data to this copied file with preserve formatting checked.  When you open the resulting output file, the macro will still be there and can be run by the end-user.  This would be the simplest way.

[Denisa_Grecu]

Hello. Thank you for the suggested solution. I also thought about it. I think it might work.