BOM export - corrupted Excel files that cannot be opened.

[M.Hawryluk]

Hi,

I use slightly modified code from:

https://forums.autodesk.com/t5/inventor-customization/export-parts-list-not-working/td-p/9776554 

to export BOM's from assembly to Excel file (Office 2016).

All works fine except that one user reports corrupted Excel files (for all his export attempts).

ILogic is firing up, temporary drawing is created, BOM is created and exported, .xlsx files is created but... can't be opened.

I checked Component Services Settings settings, tried some googled solutions (trusted views, repair Office) but no success. I didn't try to re-install Office yet.
I suspect it is Excel/Windows related issue. Any ideas how to fix it?

[bradeneuropeArthur]

Could You share your code here?

[M.Hawryluk · Accepted solution]

I reinstalled Office and it solved the problem.