×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Need File name In Design Table

Need File name In Design Table

Need File name In Design Table

(OP)
I am trying to automate the creation of the text string
"SW_Mass@@<CONFIG NAME>@<FILE NAME>.SLDPRT"

in a design table so that it can be mapper to a costom property so that it will shop up on the drawings after it is massaged.....

Using concatenate and a second sheet in the design table I can build it... except I have to fudge the file name....

can I access the sytem variable directly through the spreadsheet?

SW-File_Name

????
I am also using this to list the materials in a configuration specific manner on the drawings...

before a change in the part would update the drawing if the config was changed....

Thomas Robertson
Winch Designer

RE: Need File name In Design Table

You cannot (as far as I know) read in the filename into the design table as that would mean that you would have control to change the file name. If you were able to change the filename in a design table you would create chaos. There may be a solution. When you insert a new design table into a part the cell A1 is always called 'Design table for: 'File Name'. I am not sure if somehow you could harness the file name out of this cell using the power of excel. The only other way is to create a custom property for the Filename in the design table. For example you would do this by using a column name PRP@Filename and in the cell below type in the filename (or somehow link it to A1 cell as stated above). Hope this helps.

RE: Need File name In Design Table

(OP)
Thanks for the reply...

I am not looking to drive the file name from the design table... but to input it into a cell so i can parse it...

I can link to it in a drawing but not in a part....

Is there some clever way to make excel resolve a system variable...

maybe a VB line or 2...

RE: Need File name In Design Table

There is a way to do what you want, however, I am still trying to understand what you are trying to accomplish?  Normally, if you create a custom property that contains the mass variable, when you create a new configuration, SolidWorks will recreate the custom property with the correct configuration name (and name of the file) in it.

Regards,

Regg

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources