×
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

VBA macro not saving

VBA macro not saving

VBA macro not saving

(OP)
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!!

RE: VBA macro not saving

Are you are referencing this thread?
thread561-324428: unigraphics NX unable to read data from excel file

Quote (jpetach)

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

RE: VBA macro not saving

(OP)
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!

RE: VBA macro not saving

Quote (tryingthis)

...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

RE: VBA macro not saving

(OP)
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?

RE: VBA macro not saving

Did you restart NX after the change?

What version of NX and Excel are you using?

www.nxjournaling.com

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