I have an extremely large set of parts that need their properties edited. Is there any way to import it into excel and work there?
Depending on which properties you want to update this may be something you can achieve with the Solidworks Task Scheduler.
I've looked into this and the task scheduler is not the solution for the application I'm looking for. I'm looking to change the format of descriptions and add information in blank fields. It seems like the task scheduler will only work on batches when I need to make the same changes to many files.
Are you able to create a macro that would do the formatting for you? You could then run the macro as a custom task in the scheduler.
No, there is no pattern linking part numbers to the changes that need to be made. I've considered several alternatives, for my application I need to manually edit the properties. Doing it through Solidworks is far too tedious and time consuming though, so I would like to make the changes to multiple files in excel.
If your interested in paying someone contact Keith Rice
If you plan to manually change all fields in excel, you could instead create a drawing and insert a BOM showing all parts. You can change the fields in there, ensure you retain all links. You'd need to make sure all parts are read/write accessible.
Define extremely large....
Since it sounds like there is no pattern to your changes where a macro would help I would do what Bjorn suggests.
Throw all your parts into a helper assembly, not mated. Create a drawing from the assembly. Add a BOM with the columns set up for the properties you want to update. Edit the BOM in the drawing and save the drawing, it is a two way link to your part files. This is what I do when I am completing a large assembly. You can print a hard copy of the drawing with BOM to check your custom properties.
Or use SolidWorks Explorer. Throw all the parts into the same Windows Directory (or search around your folder structure for files) and edit custom properties in the files with SolidWorks Explorer.
If needed break it down into several passes to get through the stack of files.
Check in the API section - it would be good for you to move this over to the API discussions or start a new post there....
Yes you can but you must save your file before you try this at home.
Thanks for the Tip - Works well for individual files
Retrieving data ...