×
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

Driving variable table values with excell?

Driving variable table values with excell?

Driving variable table values with excell?

(OP)
Hi Im trying to drive an variable table value with an excell spread sheet. I can not get this to work properly.  Has anyone done this succesfully?  Any help would be apreciated.
thanks.

RE: Driving variable table values with excell?

Hi,

yes, done it, but the SE-Help has a good explanation I think. Get to
SE--> Help --> Index and under variables you will find this topic

   Create a Variable with a Link to a Spreadsheet
 
You can't, however, drive a 'driven variable' from a spreadsheet.
Those variables have a grey background.

 dy

RE: Driving variable table values with excell?

Hi
Yes, I have done this recently with very good success. Once you get the hang of it it is very easy.

- right click on your Excel cell and select COPY.
- open your variable table in SE and select the cell in the FORMULA column of the variable you want to drive.
- right click and select PASTE LINK (not paste).

If this doesn't work let me know and i will go to my workstation and run through the sequence - i my have forgotten to mention something.

A couple of things to remember:
- open the spreadsheet before you open the SE model.
- changing the name of the spreadsheet, worksheet, or moving the cell will break the link. (it is possible to change the path revision manager however)
- if you think you will need to move cells, name the cells first and the link will be ok.
- not essential but best to keep the spreadsheet in the same folder as the assembly.

I have used this process to build a user interface that works very well and i also found it easier to link values to the spreadsheet rather than between variables tables.

roger

RE: Driving variable table values with excell?

(OP)
Thanks I got it now, It seems to work very well.  I think this will be a very usefull tool for me.
thanks again.

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