VBA macro not saving

[tryingthis]

Hello,

I did a search for this and I found 1 answer. It said to search for "UGII_SUPPORT_XLSM_SPREADSHEET" in the log file and change the setting. That's great but it's not in my log file! Any other ideas? My VBA macro keeps getting deleted in all my internal sheets every time I close the internal spread sheet.

Thanks!!

 

[cowski]

Are you are referencing this thread?
thread561-324428

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

If the environment variable doesn't show up in your ugii_env.dat file (not to be confused with your log file), you can add the line and save the file. Or, you can add it as an environment variable through Windows' control panel.

www.nxjournaling.com

 

[tryingthis]

That wasn't the thread I had found but it should work. I apologize but how to I access the .dat file? I have teamcenter and I want my excel sheet to be able to be run by anyone on their own computer, to run the macro does every user have to update their .dat file?

Thanks!

 

[cowski]

...does every user have to update their .dat file?

This depends on how NX is administered where you are. Generally this file will be placed on a network location and all the workstations will look for this central file. If you are not the NX administrator at your site, you won't have the proper permissions to make it work. Contact the administrator with the variable name and value and they can get it to work properly.

www.nxjournaling.com

 

[tryingthis]

It was changed, it doesn't do anything though. I'm still losing all my macros when I save and exit the sheet. Any other ideas?

 

[cowski]

Did you restart NX after the change?

What version of NX and Excel are you using?

www.nxjournaling.com