That's what I thought as well but before I did that I went through to try each "text" file type I could and opened them in notepad to see the output. I found that saving as a Formatted Text (Space Delimited) .prn file type allowed me to keep the quote formatting the way I wanted. Now it imports...
I appologize for not being more thorough. I have created a macro in VBA to create a large number of .exp files by bringing data in from a master data sheet containing all the dimensions, filenames, and materials for each part. I store these exp files in a folder that the journal in UG pulls from...
John,
I decided to try your manual method to import a string to start my troubleshooting. This is lies with the file format that I am using in excel. When I save my .exp I am using a Tab Delimited Text file format. However, this format does not like quotations. It adds additional quotations in...
There must just be something wrong with my syntax somewhere between the macro writing the .exp and the journal importing. This confirms that I can atleast import as strings using .exp's.
Thanks for your help John!
John,
The journal loads a different .exp file for each of about 10,000 drawings. I load the dimensions this way so I thought it would be easier to just load my part number and type using the same exp file. The type is really the issue because it is letters like "STD", "BEVEL", and "SQB". In the...
UG NX 5
Windows XP 64-Bit w/Excel 2007
I am importing .exp files into UG using a journal file to create a large amount of drawings. I have done this successfully with other product lines but now I need to import a few string variables into the model. The problem is, UG seems to be adding extra...
I am using office 12.(2007) Still no luck. I will try some modifications and possibly do a read from excel with it opened manually.
Thank you for all your help!
Frank,
Thank you for the sample program. I tried to execute it but it came back with an error, most likely due to something I am doing despite your efforts. I appologize for that. I have attached a picture of what I am getting back from NX when I execute the program as an NX open.
Thanks for...
I would like for the dimensions of the model to change and save a .pdf for each iteration from the spreadsheet.
I am using version 5 but have version 7.5 capability if there is a newer function to make this possible.
I have been trying to automate a process of making around 2000 drawings with dimensions in an excel spreadsheet. I have a master template but need to change a few dimensions in each drawing.I have tried to use part families but I can not effeciently generate drawings using this method. Is there...