Goal:
Is to use an embedded Excel Design table in a Part or Assembly fileto automatically "read" the embodying filename (ie of the Part orAssembly) then split it into pre-defined custom parameters (mayneed some VBA for this...) representing fields that need toautomatically update and populate a drawing title panel etc.
Our current filename convention is as follows;
nnn_xxxx_yyy_A##_description
Where nnn = the product (ie project) number allocated at the startof the project.
xxxx = identifier (Incremental number unique to each part)
yyy = Document Type Descriptor, number: See below
· 100 for mechanical drawings
· 110 for mechanical assemblies
· 111 for PWA's
· 200 for schematics
· 500 for artworks
A = version (letter), used to capture fit, form or functionchanges used in Part, Assembly and Drawing documents
## = revision numbers, eg 01, 02, 03 etc (used for drawing filesonly)
The main problem we face is that we have not been able to "extract"the complete filename inside the embedded Excel Design Table tofeed into the associated internal VBA scripts for string operationsto split them into individual parameters. (The AIM: is to set acustom parameter say "PartNumber" = nnn_xxxx_yyy , "Version" = A,"Revision" = ##, and "Description" = description , we will probablyalso need to find a way to increment and store the various Versionand Revision numbers along with an ECR number and Change Note,ChangedByUser and ChangedDate ... to track each change through thecomponents lifecycle...in say an automated Revision table...)
Ideally we would like to have our start parts and assembliescontain the embedded Design Table and as the file is given a namethe spreadsheet would "instantaneously" update the fields in thedesign table so they would automatically propagate into the drawingtitle panel fields and also be available later for use with PDMif/when we update to it.
Regards,
KenSolidworksConfigurations design Tables
Is to use an embedded Excel Design table in a Part or Assembly fileto automatically "read" the embodying filename (ie of the Part orAssembly) then split it into pre-defined custom parameters (mayneed some VBA for this...) representing fields that need toautomatically update and populate a drawing title panel etc.
Our current filename convention is as follows;
nnn_xxxx_yyy_A##_description
Where nnn = the product (ie project) number allocated at the startof the project.
xxxx = identifier (Incremental number unique to each part)
yyy = Document Type Descriptor, number: See below
· 100 for mechanical drawings
· 110 for mechanical assemblies
· 111 for PWA's
· 200 for schematics
· 500 for artworks
A = version (letter), used to capture fit, form or functionchanges used in Part, Assembly and Drawing documents
## = revision numbers, eg 01, 02, 03 etc (used for drawing filesonly)
The main problem we face is that we have not been able to "extract"the complete filename inside the embedded Excel Design Table tofeed into the associated internal VBA scripts for string operationsto split them into individual parameters. (The AIM: is to set acustom parameter say "PartNumber" = nnn_xxxx_yyy , "Version" = A,"Revision" = ##, and "Description" = description , we will probablyalso need to find a way to increment and store the various Versionand Revision numbers along with an ECR number and Change Note,ChangedByUser and ChangedDate ... to track each change through thecomponents lifecycle...in say an automated Revision table...)
Ideally we would like to have our start parts and assembliescontain the embedded Design Table and as the file is given a namethe spreadsheet would "instantaneously" update the fields in thedesign table so they would automatically propagate into the drawingtitle panel fields and also be available later for use with PDMif/when we update to it.
Regards,
KenSolidworksConfigurations design Tables
