Using excel commands within a NX macro
Using excel commands within a NX macro
(OP)
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!
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!





RE: Using excel commands within a NX macro
That being said, I'll let some others here respond since they have much more experience creating Journal and perhaps updating them into full-blown programs.
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.
RE: Using excel commands within a NX macro
Thanks!
RE: Using excel commands within a NX macro
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.
RE: Using excel commands within a NX macro
Thanks!
RE: Using excel commands within a NX macro
It will probably be easier to query the PMI object for the desired information and put it in the table directly, bypassing the PMI report entirely.
www.nxjournaling.com
RE: Using excel commands within a NX macro
Mainly, I need to get the value, appended text, and tolerances from the PMI dimensions... What do you think?
RE: Using excel commands within a NX macro
www.nxjournaling.com
RE: Using excel commands within a NX macro
Thanks!
RE: Using excel commands within a NX macro
PMI_dim_table.vb
www.nxjournaling.com
RE: Using excel commands within a NX macro
Other than that, this is just great! exactly what I was looking for. Thank you very much cowski!
RE: Using excel commands within a NX macro
Glad to hear it helps.
www.nxjournaling.com
RE: Using excel commands within a NX macro
Thanks!
RE: Using excel commands within a NX macro
www.nxjournaling.com
RE: Using excel commands within a NX macro
Best Regards.
RE: Using excel commands within a NX macro
www.nxjournaling.com
RE: Using excel commands within a NX macro
RE: Using excel commands within a NX macro
Updated code
www.nxjournaling.com
RE: Using excel commands within a NX macro
Best Regards.
RE: Using excel commands within a NX macro
I have another question for you, sorry for bring it up after a while... Is that possible to get also the dimensions contained in a whole assembly?. This journal works perfect with isolated parts, but when I'm trying to use it for an assembly, it just draws the headers of the table; which I think is expected because the dimensions are contained in the parts or subassemblies, not in the top assy. Do you think is possible to get the complete dimensions table contained in the assembly?
RE: Using excel commands within a NX macro
www.nxjournaling.com
RE: Using excel commands within a NX macro