NX-Excel Link

Submitted by Mu5 on Thu, 02/11/2021 - 22:25
Forums: 
General Discussion

Hello

I am trying to create an Excel interface that is linked to an NX master model where a user would be able to drive model dimensions, generate CAM data, produce engineering drawings, plot graphs etc all without having to leave the Excel environment. Is it possible to run journal code in Excel as macros? So I want to, for example, embed the journal code of updating part expressions within an Excel button to automate that process.

Thank you

NXJournaling - Mon, 02/15/2021 - 07:37

"Is it possible to run journal code in Excel as macros?"

To the best of my current knowledge, it is not possible to directly run NX journal code from Excel macros. However, NX does have the "run_journal" utility that allows you to start a journal (in batch mode) from other code. I've not tried to use this utility from Excel macros, but I think it would be possible.

If you have an NX author license, you might be interested in "remoting". I don't have access to an author license, so I've not tried it; but my understanding is that you can control an existing NX session from your external code via remoting. If this is of interest, I know the NX programmer's guide has more info and an example ships with NX.

Mu5 - Tue, 02/16/2021 - 03:20

Thanks for that. I don't have an NX author license either but I'll try using the utility and see how far I get.