Output corrupt excel xlsx file

Tmanuela

Hi, 

My flow seems to output corrupted excel files rendered from a db, and the output tool is set up to output to a new filepath created beforehand with a formula tool. 

I see it is corrputed when I run a VBA macro on an excel template that needs to open this output files from Alteryx..and because of this error I can not run my VBA code.. 

Any thoughts?

Pretty urgent.

Thank you!

M.

jamielaird

Hi @Tmanuela ,

I found this post from @MsBindy which suggests a way to solve this by adding a command into your VBA to repair the file.

Sub Import_Click()

Application.DisplayAlerts = False

Workbooks.Open "filepath/filename.xlsm", CorruptLoad:=XlCorruptLoad.xlRepairFile

End Sub

Source: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-Excel-error/m-p/49277/highlight/true#M18747

Another suggestion, from @Amilykassia is to update your Protected View settings:

1. Go over to the File Menu and click on Options
2. In the Options window, choose the last tab,Trusted Centre
3. Now click on ‘Trusted Center Settings’
4. In the new window, choose ‘Protected View’
5. Unchecked all the options available and click OK

Source: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-file-corrupt-after-writing-output/m-p/452096/highlight/true#M87447