I have a situation where I have a fairly complex sketch with several driving dimensions with a number of linked driven dimensions that I need to extract into an excel spredsheet or SolidWorks table.

What I need to do is vary the driving dimensions in fixed range and step (so say a range of 1000 to 3000 in increments of 100 - so 1000,1100,1200,1300 etc) and record the resultant driven dimension value.

I can of course do this manually, but there are probably something like 1000+ variations - so it is a lot of manual editing and recording.

So does anyone know of a way to take a single sketch, apply a change to one driving dimension, and record the value of all the driven dimensions to either a SolidWorks table or to an external Excel spreadsheet?