cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Driving a part from excel

PhilJarvis
Newbie

Driving a part from excel

Hi We have a very straightforward design with only a few dimensions that I would like to drive from an external excel file, so that when you put the values in and press a button a macro will modify an existing part to these dimensions in Pro/E. The idea is that I would like to make the part file write-protected so that any number of users can drive the part, but that ultimately it cannot be modified. As it is for a design calc that uses ANSYS to analyse the part once the dimensions have been entered, I would ultimately like to have the macro launch ANSYS and run the analysis also, but one step at a time! Anyone know how to help me get going? Many thanks Phil
This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
9 REPLIES 9

RE: Driving a part from excel

Hi Phil I've done a similar thing in the past using family tables....then creating advanced macros..to fully automate....which version of wf are you using? can you send me the part? Ben www.edgepd.co.uk

RE: Driving a part from excel

Hi Ben I'm on Wildfire 4 at the moment. Family tables won't really help as there are too many permutation with the design, however I'm happy to send you the part. What's your email address? Cheers Phil

RE: Driving a part from excel

Have a look at my profile. You should be able to see my email from there. Don't want to broadcast on net for spam reasons Can you save as WF3 to? not upgraded yet Thanks Ben

RE: Driving a part from excel

Hello Phil, so what you need is to control the program of the assembly or parts from excel. in order to do so you have to declare in each part or assembly file that you need, the parameters name which will be input from excel Click tools - program.. - Edit design then you'll find this: INPUT END INPUT Now, between the imput lines is where you tell the program which parameters values will come from an outside reference, in your case an excel file (by the way same as mine, I've been working this way almost three years ago, and there is a huge potential in this tool, only is a bit awkwward to master) Parameters need to be declared in a specific way, for example HOLE_DIAMETER NUMBER PATTERN YES_NO BOLT_NAME STRING Those for the 3 kind of parameters Pro/e recognizes Then you close the program, say yes, you want to include changes, and then you tell the program where you want to read the info from. Now the thing is that pro/program only reads .txt files. This file needs a specific structure, the first colom is the parameter name, the second colom is an = ,and the thrid colom is the param value. As soon as the program finds a blank row in the file it stops reading it. So you have to manage the excel file to have this format, and then save that sheet in a txt file. Then when pro/e asks you the file from where it should read th data, you write down te .txt filename complete, including the .txt (this is viable with a fine excel macro) It will only read it from the working directory, nor anywhere else, so make sure you create or copy the txt file into that directory. If you neer further details or info, please let me know, I may send you some example to a personal e-mail regards

RE: Driving a part from excel

Thanks very much Claudio! Ben - I have your address and I'll send the parts as soon as I find a decent way to convert to WF3 (all I can do is STEP so far which loses the parameter values I have assigned to the dimensions... ) In the meantime I will give what Claudio suggests a try...

RE: Driving a part from excel

Claudio; I tried your procedure as I have the need to do something similar, and it returns a blank value once I regenerate, select the .txt file, and go tools -> parameters. The name and type are there (In my case "Code" and "String", but the value is blank. Any suggestions?[/quote]

RE: Driving a part from excel

Hi Claudio Can you help me ,i don't understand how to use the command. Can you give the example to me and tell me the detail process. ths

Re: Driving a part from excel

Simplified Logic Inc specializes in bi-directional Excel to Creo or Creo to Excel data transfer this with an application called Nitro-CELL.  Please see this Website: Simplified Logic, Inc. and YouTube Channel:  Simplified Logic, Inc. - YouTube

Re: Driving a part from excel

have  a look here too

Announcements