×
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

NX Expresssion/Function Question (ug_excel_read)

NX Expresssion/Function Question (ug_excel_read)

NX Expresssion/Function Question (ug_excel_read)

(OP)
Hi,

I have some parts in UG NX4 containing expressions that are updated from an external spreadsheet.  When I use the function "ug_excel_read" I am asked to specify a spreadsheet.  When I use the menu to locate the spreadsheet it automatically populates the file path into the function formula.  This works fine as long as my spreadsheet stays in the same location.  If I move the spreadsheet to a different folder or location everything blows up.  Is there a way to either make the file path a variable that I can change throughout all of the expressions in my part or can I leave it blank and have it default to searching for the spreadsheet in my working directory?  All of this is assuming I am working in native UG right now.  If more explanation of my problem or what I am looking for is needed, please let me know.  Any advice is appreciated!
 

RE: NX Expresssion/Function Question (ug_excel_read)

No, the path needs to explicit and up-to-date to work.

That being said, what exactly are you using the 'external' spreadsheet for?

John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.
 

RE: NX Expresssion/Function Question (ug_excel_read)

Is it possible to store the spreadsheet on the same drive/folder that your NX files are resident in?

RE: NX Expresssion/Function Question (ug_excel_read)

(OP)
Thanks for the replies!  John, I have an assembly that I am scaling based off of some design calculations and macros in an external spreadsheet.  All the calculations are performed in the spreadsheet, it is saved, and then I refresh my parts in UG with a macro to get the new geometry.  My problem is that sometimes I need to allow another user to utilize my spreadsheet and UG parts.  If they copy the files to a folder on their machine, all the file paths in all of the parts need to be changed.  If there is not a way to avoid this, is there a better way to accomplish what I'm trying to do?  Thanks!

RE: NX Expresssion/Function Question (ug_excel_read)

(OP)
Is there a way I could put the parts and spreadsheet in Teamcenter to allow others access and solve my problem?

RE: NX Expresssion/Function Question (ug_excel_read)

Actually the Teamcenter solution would be the best long term one if this is going to be a common part of your workflow.

John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.
 

RE: NX Expresssion/Function Question (ug_excel_read)

That is true John. I wish our IT system allowed that. Even their knowing that having the spreadsheet stored in a vulnerable area...MY USER Folder, they seem to be intransigent.

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