×
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

variables from excel to SE draft

variables from excel to SE draft

variables from excel to SE draft

(OP)
Hello,

I have in my project folder an excel file with some data - "projectNr", "Engineer", etc...
All dft par ans asm are in the same folder as the excel.

When i make drafts, i want to include that excel data in my titleblock automatically - Is it possible?

thx, Johan

PS: i don't want to link/expose variables in all parts separatly, but get the data straight from excel.

RE: variables from excel to SE draft

You appear to be mixing PROPERTIES and VARIABLES.
Normally the data you use in a title block will come from file properties - either the model or the drawing.
I don't think it's possible to link a property to a field in an excel file.
It is possible to link a variable to excel, but you would still then have to expose the variable in the part or assembly to get it into the draft file, and you can't have text variables - its numbers only

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

Where would we be without sat-nav?

RE: variables from excel to SE draft

(OP)
Indeed - Normally the data you use in a title block will come from file properties - either the model or the drawing.

so i can't include data that is in an excel file? maybe a small vb script to get that data?
 

RE: variables from excel to SE draft

I vaguely recall something perhaps similar from PLM world 2006.  Some medical device company read in stuff from their ERP system into Solid Edge using some kind of script or Macro.

Can't remember enough to be helpfully though, sorry.

Posting guidelines FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm? (probably not aimed specifically at you)
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?

RE: variables from excel to SE draft

Yes, you could do it with VB macro, but it wouldn't be a dynamic link.

The macro would open the excel file and read the appropriate data.
Then it would copy the data to the draft or model file properties.
By using property text callouts in the draft the value would update the drawing title block.

At a previous company they were going to do it the opposite way round - the property values stored in the drawing would be read into the erp system.

Unfortunately there were so many properties you couldn't remember which ones needed to be completed, so I wrote a VB program that replicated the drawing title block as a form that was completed on-screen and which saved the values into the file properties.

Some of the data was standard for each project, so there was an option to choose a 'project file' where that specific data was stored. This was simply a text file that I could read the values from.

Does that make sense?

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

Where would we be without sat-nav?

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