Is there a macro that copies custom properties to Excel?
Is there a macro that copies custom properties to Excel?
(OP)
Hello,
We are looking for a macro that does the following:
1) With an assembly open, it copies all the custom properties of the components into an Excel table
2) You then can change the values in the Excel table, and then update automatically the custom properties in the components to reflect the new values in the table
Has anyone seen any software that does this or something similar?
Cheers,
We are looking for a macro that does the following:
1) With an assembly open, it copies all the custom properties of the components into an Excel table
2) You then can change the values in the Excel table, and then update automatically the custom properties in the components to reflect the new values in the table
Has anyone seen any software that does this or something similar?
Cheers,






RE: Is there a macro that copies custom properties to Excel?
Matt
CAD Engineer/ECN Analyst
Silicon Valley, CA
sw.fcsuper.com
Co-moderator of Solidworks Yahoo! Group
RE: Is there a macro that copies custom properties to Excel?
We were wondering if there was an existing add-on or product that could do this. It does not have to be Excel per se.
Unfortunately, a design table can only control the custom properties of the active document. We want to control all the custom properties of all the components in one assembly.
cheers,
RE: Is there a macro that copies custom properties to Excel?
OK, that explanation helps. Try the macro FixProperties found at http
Matt
CAD Engineer/ECN Analyst
Silicon Valley, CA
sw.fcsuper.com
Co-moderator of Solidworks Yahoo! Group
RE: Is there a macro that copies custom properties to Excel?
Propagator from http://www.customsolids.com>
PropertyEditorGlobal from http
SWcp3 from http://www.swcp3.com/
Update Custom Properties from within the SW Task Scheduler
RE: Is there a macro that copies custom properties to Excel?
RE: Is there a macro that copies custom properties to Excel?
Thank you all, these all seem to be very helpful macros.
Cheers,
Joseph