Can someone show me how to write a macro for the following tasks? I can’t figure out how to Update Values (steps 1-4) within Excel.
- Open Part #1
- Edit Table or Edit Table in New Window
- Edit Links
- Update Values
- Open Part #2 and repeat steps above
- Open Part #3 and repeat steps above
- Open Assembly #1 and repeat steps above
One method is to have the externally linked Excel file already open before opening the Design Table but this method fails now with the Solidworks message “Insufficient memory to perform operation”. This error message appears on some part/assy. files but not on other files.