Macro to Copy All design data out (& back in) of a model

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:

ValueIn FeatureFull Dimension NameLink
45PLANE1D1@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