- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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