Export BOM to excel and change sheet tab name to Assembly

[Anonymous]

I am currently able to export the BOM to an excel file, but am having trouble on how to automatically change the Excel tab name to the Assembly name. I was hoping that this may have been done before, or if I could be guided in the right direction? Thanks in advance!

[lena.talkhina]

Hello @Anonymous !

Great to see you here on Inventor Forum.

Did you find a solution?
If yes, please click on the "Accept as Solution" button as then also other community users can easily find and benefit from the information.
If not please don't hesitate to give an update here in your topic so all members know what ́s the progression on your question is and what might be helpful to achieve what you ́re looking for. 🙂

[Anonymous · Accepted solution]

Yes I found the solution. In your excel template just add some VBA code to dynamically update the sheet tab name that way when you export the BOM the VBA code will automatically run.