We have a few thaousands of drawings in which all descriptions have been generated by calling out a PRP in the "value/text Expression" colume in order to get the final text in the "evaluated value" column
eg: typing
$PRP:"SW-File Name", $PRPSHEET:"Material" in the Value text expression column
results in :
1000001, ASTM A36 Steel in the Evaluated Value column
the problem comes when trying to extract these values into a spread sheet in order to provide a list of specific properties
as the text extracted is not the evaluated value see below for clarification:
In a perfect world, what I would like is:
- Run Macro
- Prompt user to select folder containing Drawing files that macro will run on
- Extract Evaluated Value of Property "Description" and Property "Part Number" from the first drawing
- Open excel worksheet
- Place evaluated values into worksheet
- Place First Evaluted value of "Part Number" into cell A1
- Place First evaluated value of "Material" into cell B1
- Open next drawing in list
- extract those values
- place evaluated values in the same worksheet in cells A2 and B2
- Repeat until all drawing files are processed
- User then saves that one worksheet at their desired location
I have been able to find some inclings of code that imply that this is possible
Similar posts on extraction here, here and here. Also found the attached macro from a Forum thread (apologies I cannot recall whichone to credite the user)
Partial idea to exctract evaluated value from here
But I have no idea how to merge thes together and modify into one macro and to also modify it so it extracts the data into the same, alread open worksheet.
#task does have a custom property bulk export but it is for all properties and on separate excel files I believe
Any help woul dbe greatly appreciated as I do not have any macro experience.
thak you