Using excel commands within a NX macro

[someonedflr]

Hello everyone

I stepped into a problem while trying to automate a task (I'm pretty novice about NX customization, just starting with simple examples and following the Help guides). I'll try to be as clear as possible:

I need to take some information from the PMI report spreadsheet and place it into a table.

Problem 1: It seems that journaling doesn't support PMI report command (Information > PMI > Report). Is there a workaround to use this command in journal?

Problem 2: Then, I decided to try with macro recording. It launches the Excel spreadsheet succesfully, but I can't find the way to add some excel handling commands to the NX macro (e.g. Copy, Cut, Paste some columns). Is it possible to launch the excel spreadsheet, use these excel native commands, and then return to NX application by using a macro?

BTW, I'm using Windows XP, NX7.5

Any help is appreciated!
Thanks!

 

[cowski]

I'd suggest setting up a 'container' to hold all the data (2d array, data table, collection, etc), cycle through the components making each the work part in turn, collect the PMI dimension information (as done in the journal) adding the info to the 'container' of choice, and finally switch back to the assembly file to create the tabular note using the information from the 'container'. Bear in mind that the tabular note contents are not associative to the PMI dimensions; if/when any component changes, the tabular note will need to be updated or recreated.

www.nxjournaling.com

 

[someonedflr]

OK, sounds good, I'll give it a try. Thank you!