Macro for output the data in excel

Question

Hi Everyone.

I need someone who can help me in creating a macro for my output in excel. I have the below data set where, I want to write the data based on the intercompany in different excel tab of my output file.

CCYLE N AccountS AccountC CenterInter CompanyProductTrans TypeEnding BalanceUSDxxxxxxxxxxxxxxx00100-14.1USDxxxxxxxxxxxxxxx00100-30JPYxxxxxxxxxxxxxxx0025000040JPYxxxxxxxxxxxxxxx0025000024USDxxxxxxxxxxxxxxx00250000-3116.25JPYxxxxxxxxxxxxxxx00250900110050AUDxxxxxxxxxxxxxxx00308000-1195JPYxxxxxxxxxxxxxxx003500001346USDxxxxxxxxxxxxxxx00350000-2616JPYxxxxxxxxxxxxxxx0805CN9391500125USDxxxxxxxxxxxxxxx007501001160USDxxxxxxxxxxxxxxx0075010041.2USDxxxxxxxxxxxxxxx090052D760600-998.81USDxxxxxxxxxxxxxxx00780200418.2USDxxxxxxxxxxxxxxx090052D789000-355.38

My output file is fixed with all the intercompany tab names in it. Below are my requirements:-

1) I want this to achieve by macro only

2) All the possible Intercompany names tab will be there in the output file. There are some formula also in each intercompany tabs, so we need to write the data in specified area only i.e. A1 to K20.

3) There are high possibility that we will not get all the Intercompany every time. Hence, I want alteryx to clear the previous data for those intercompany where we do not have the data in current period.

CoG · Answer

Do you have AMP engine enabled? This can occasionally cause that error to be thrown. Try disabling in "Runtime" settings in Configuration pane for workflow. What Alteryx Version are you running?

akumar2609 · Answer

Hi Andrew,

Thank you for replying on my query.

Not sure, I am getting the below error message :- Error: Output Data (6): Unable to create backup of C:\Users\Desktop\Alteryx Examples\Tabbed_Output workflow (1)\Tabbed_report.xlsx to C:\Users\Desktop\Alteryx Examples\Tabbed_Output workflow (1)\Tabbed_report.xlsx.bak: Access is denied. (5)

To avoid the above error message, my preference was to move on Macro, however doesn't succeed in that also.

Could you help me in getting it resolved?

CoG · Answer

Still not sure why you would need a macro:

Tabbed_Output workflow.yxzp