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.
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
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
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
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...
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]