Howdee group,
I have an assembly for which the geometry of individual parts is updated through design tables. The overall dimensions of the assembly
always change, so I've devised a system to automatically update the
parts as required: I use one "master" excel table to calculate the
overall geometry of the assembly and individual parts, and then run a
VB program which goes through all the parts to open each part's design
table in order to update/pass information from the master excel table
(when each design table is opened, it automatically updates from the
master table and thus the part is updated). This works pretty well,
except now I would like to make the parts generic so that one part can
be used for different assemblies (which would be defined by different
master tables).
The problem I now have is that the design tables of each of the parts refer to the original master table I made for the first assembly. I can replace the excel references in each part, but then I would need to duplicate the parts for each new assembly design, and I would rather just keep one version of each part.
Is there a way of creating some type of global variables which can (1) be updated from excel, and then (2) read by a part's design table when it is opened?
- I suppose this might be more of an excel than a SW question...
Thx a bunch.
I have an assembly for which the geometry of individual parts is updated through design tables. The overall dimensions of the assembly
The problem I now have is that the design tables of each of the parts refer to the original master table I made for the first assembly. I can replace the excel references in each part, but then I would need to duplicate the parts for each new assembly design, and I would rather just keep one version of each part.
Is there a way of creating some type of global variables which can (1) be updated from excel, and then (2) read by a part's design table when it is opened?
- I suppose this might be more of an excel than a SW question...
Thx a bunch.