×
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

Transferring Variables

Transferring Variables

Transferring Variables

(OP)
Hello
I have figured out how to transfer data from Excel to Solid Edge, and control the suppression of features. Pasting links etc...
Can I get a variable from Solid Edge back into Excel?
Can I get Excel to Suppress/Hide/Inactivate parts in an assembly?
Thanks in advance
 

RE: Transferring Variables

Yes it looks like it can be done, and it's the reverse of what you do to get the link from Excel to SE.
In the SE variable table right click on the value you want to transfer and select Copy Link. Then in the Excel sheet right click on a cell and select Paste Special. You should then in the box select the Paste Link option.
As for suppressing etc. parts in an assembly I don't think you can do that. The only suppressing you can do with the variable table (hence Excel) is with part features.
You may be able to do it using some VB code though.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

RE: Transferring Variables

(OP)
thank you

RE: Transferring Variables

Hi,

the way BC did outline the procedure is OK. But be warned
starting Excel will start SE as a background process
to fetch the variable's value. Upon closing Excel SE
will not be closed, however, so it will remain active
as a bckegound process (SE V10/sp12, XP Excel 200). You
have to terminate it manually by using the TM

dy  

RE: Transferring Variables

Good tip Don, never thought of that.
Just checked it the opposite way (link from Excel to SE), and SE does start Excel if a variable is linked to an Excel sheet but Excel is terminated correctly when SE is exited.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

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