Cancel
Showing results for 
Search instead for 
Did you mean: 

Re: Live Export to Excel

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor
I could reproduce your error: it happens, if you have some failures in the Plant Simulation object path/attribute names. This causes a formula error in Plant Simulation and the error 2147221503 in VBA
check your paths or try bearbeitungszeit instead of procTime
Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net

Re: Live Export to Excel

Experimenter
Experimenter

Thank both of you for your help and patience. It works now!

I changed the security settings of the folder and changed the path to "...Bearbeitungszeit" instead of "...ProcTime". Even though the language in the model settings was set to english..

Re: Live Export to Excel

Creator
Creator

Hello, I would like to select Points in NX and have the coordinates displayed in an Excel file.

I just succeeded in displaying the coordinates in an information box in NX:

 
Option Infer On
Import Snap

Module MyProgram

Sub Main()
For Each pt In Snap.Globals.WorkPart.Points
Snap.InfoWindow.WriteLine(pt.Position)
Next
End Sub

End Modul

 

I have not found the transition that they show in an automatically opened Excel file. Is it even possible to open with programming in NX Excel and to go further in this file? 

Is there already a sample code here?

 

Thanks 

Re: Live Export to Excel

Phenom
Phenom

I guess you posted your question in the wrong forum.

 

This is the Plant Simulation forum not the NX forum