×
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

Solid Edge ST2 Excel Link for Synchronous Part

Solid Edge ST2 Excel Link for Synchronous Part

Solid Edge ST2 Excel Link for Synchronous Part

(OP)
The instructions for linking a Solid Edge part to an Excel sheet (so that I can dynamically drive dimensions in the part from the Excel sheet) don't seem to work for Synchronous Part in ST2.

Is there a way to make this work for Sync parts?

RE: Solid Edge ST2 Excel Link for Synchronous Part

If you look closely at the variable table, there is a column named Value.
At the right side of the variables that are dimensions, there is a lock tab.
This must be selected, and show locked in order to drive the dims via an excel worksheet.
Then, click on the cell in the excel worksheet that has the value you wish to drive a variable with and select copy.
Move back to the variable table, and right click on the formula cell for the variable you wish to drive, and select paste link.

I use it in history based quite a bit, and just tried it in syncronous, and it worked fine.

 

-av8errr
Solid Edge ST3 MP9
HP Z400 W3565 @3.00GHz
Win XP X64
15GB RAM
NVIDIA Quadro 2000     
 
 

RE: Solid Edge ST2 Excel Link for Synchronous Part

(OP)
Hi av8errr, thanks for your reply. I tried to look for the "lock tab" in the variables table that you point out, but I don't see it. I've attached a screenshot of the variables table and my part -- perhaps you could point out what you're talking about?

If I am unable to drive dimensions from Excel, I would at least like to drive them from the Solid Edge variables table.

I should also note that this is an academic license of ST2 (I work at a university lab); perhaps that explains it?

RE: Solid Edge ST2 Excel Link for Synchronous Part

(OP)
Addendum: Perhaps this is a feature that was not implemented in ST2 but was implemented for ST3? I see you are using ST3.

RE: Solid Edge ST2 Excel Link for Synchronous Part

From your screen shot, it appears that all of your dims are driven.
Outside of the variable table, and in the model....try to click on a dim.
A window should appear that you can type a dim into.
Adjacent to the field is a lock, which will appear unlocked.
Click on it, so that the dim is locked, or driving.
Now check your variable table, and past the link of the correct cell from your excel document.

-av8errr
Solid Edge ST3 MP9
HP Z400 W3565 @3.00GHz
Win XP X64
15GB RAM
NVIDIA Quadro 2000     
 
 

RE: Solid Edge ST2 Excel Link for Synchronous Part

(OP)
Oh, perfect. That works. Thanks very much!

(You'd think Siemens could write this into the help file! It looks like the help file was written for history-based modelling, since it doesn't mention anything about having to lock the dimension before being able to use variables to control it.)

RE: Solid Edge ST2 Excel Link for Synchronous Part

Glad to help.

-av8errr
Solid Edge ST3 MP9
HP Z400 W3565 @3.00GHz
Win XP X64
15GB RAM
NVIDIA Quadro 2000     
 
 

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