Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Internal Spreadsheet and VBA Macro

Status
Not open for further replies.

budanod

Mechanical
Joined
Aug 10, 2011
Messages
1
Location
DE
Hello !

I just spend a lot of time to search informations about my problem but I didn't found anything..

Actually, I'm trying to create a model in NX (a Spring) which have links with the internal spreadsheet of the part. The goal is to calculate mecanicals propreties according to the part dimensions.

I have created all parameters in "Tools->Expressions", than I was in "Tools->Spreadsheet->Add-ins->Extract Expr".

I have created a new sheet with all calculations and a nice layout. Now I have created some macros in order to have a both sides values updating (when I change a value on the Calculation sheet it will update the "NX Sheet" and then the part and when I'm opening the Internal Spreadsheet, if I have changed values in "Expressions" the calculation sheet is updated).

My problem is : When I'm leaving the Spreadsheet, all my VBA Code is not saved...

How can I fix it ?

For informations, I'm using NX 6.0.5.3.

Thanks for your help and sorry for my english..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top