Create Batch Macro to spilit in multiple excel sheets.

Question

Hi Guys,

Would you please help me to create batch macro that can produce an excel file with the separate sheet for each technology in the data.  So, if data has three technologies than macro will produce three sheets for each technology in one excel file.  This is because of I have to create excel formulas and placing each technology on separate sheet gives me control on building formulas in Alteryx.

Macro has to applied before creating excel formulas.

Any given help is much appreciated.

New Workflow6.yxmc

AC · Answer

hello Terry,

Thankyou for your reply.

Actually, I have to create batch macro and reason behind it is I have to create formulas in Alteryx  for each teachnology on separte excel sheets. These formulas should always starts from First Cell A for each technology in Excel output file.

Here Techology C is Starting from Cell C6

Here Technology B Start from C3

They both need to start from same Cell.

I have attached another version of WF. Hopefull you will be albe to open this one.

Thanks again  for your valuable time.

AC

Data_test.yxmd

binu_acs · Answer

@AC You don't need a batch macro to create separate tabs in the same file, create a file path where you want to save the output file with the file name and use the technology as sheet names. Attaching a sample workflow for your reference

Sample_110523.yxmd

terry10 · Answer

@AC

I can't open the macro you attached, but I think there is a super simple way to do what you are trying to do without a batch macro!

See the attached example. The Output tool can be configured like this to create a separate sheet based on the values in a field. In this case, I selected Region, so I ended up with 4 sheets in the output Excel.

Multi-sheet output.PNG

Multi-sheet output Configuration.PNG