Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
tmuel
in reply to: cain.hillier

I am working through a similar challenge. I have multiple parts lists on multiple sheets. I am looping through using the export parts-list function and pushing the information into a single excel spreadsheet. I have found that if a table (worksheet name) is specified during export to excel, and that table exist it will prompt to overwrite. If a table is not specified it will append another worksheet to the same excel document. This is the behavior I am looking for as a user may need to do this from multiple drawing files, into the same spreadsheet.

 

The result is a spreadsheet with many tabs, then we are pulling that into another single worksheet with a macro. 

 

If you want to push them to spreadsheets with different names, you would probably want to build a naming scheme that included the sheet and parts list loop counter

 

Hopefully that clarifies.

 

 

Tim