unigraphics NX unable to read data from excel file

[defaultrush]

i have a assembly which uses data from a workbook, it is unable to read the workbook if it is macro enabled workbook, is there something other format which it can access a macro enabled worksheet .

 

[JohnRBaker]

Exactly how are you accessing the Excel file from NX?

And what version of NX are you running?

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

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

 

[defaultrush]

i have used ugcellread in expressions.i am using NX7.5

 

[JohnRBaker]

I just treid this using NX 7.5.5.4 and Excel 2007 and it seems to work fine. Now all I did was create the spreadsheet and toggle on the 'Enable All Macros' option on the 'Trust Center' dialog. I don't actually have any macros created for this spreadsheet, I just enabled the option, which was what you implied was all that you had done.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

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

 

[defaultrush]

Actually what i have is a macro enabled excel file (.xlsm) and a macro which runs during the initialization which opens up a user form and hides the worksheet application . when i change the values in the worksheet, save it and refresh the values from expression, ug cannot read the excel file.

 

[jpetach]

Defaultrush,

Set the environment variable UGII_SUPPORT_XLSM_SPREADSHEET=1
This can be done in "%UGII_BASE_DIR%\ugii\ugii_env.dat"

HTH, Joe