Hello,
I was hoping someone might be able to help me with two macros I am trying to write.
Macro 1 - "Read Data"
Will start with an active assembly and reads all design data, from a model and puts it into excel - say "Sheet_1";
It would move down the assembly, capturing the mates data, drop-down parts for the features and sketch data and export all of it to a specific Excel file
I have tryed to modifing a macro that Josh? wrote which outputs something like this:
Value | In Feature | Full Dimension Name | Link |
45 | PLANE1 | D1@PLANE1@C7932-SA-010.Assembly |
I would ideally have it output the above information, from all (unsuppressed) features into a specific Excel spreadsheet. It would be good if it could also capture bilateral tolerance information from dimensions.
Excel - I could then do basic tolerance analysis (TA) on the dimensions etc.. I could then run Macro 2:
Which coppies the values from "Sheet 2", back into the correct places - and updates the models.
Running Macro 1, Doing the Ta, then Running Macro 2 could be repeated as the TA chains are updated - thus speeding up the process.
If anyone can help out with little bits of code (or the whole thing ;-)) I would be very greatful,
Thanks & Regards
Guy
(Currently Running SWks2008 SP5 - (About to upgrade to SWks2009)) WinXP 32bit
SolidworksApi macros