06-21-2006 03:28 AM
06-21-2006 07:08 AM
Hi David
Record what you want to do as a macro in excel. Then use the excel VB Editor to view the code. This will let you see objects, methods and properties used. Then its a matter of converting the VBA code into labview property and invoke nodes.
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 21/06/2006 by dcrawford
'
'
Cells.Find(What:="1", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
Rows("1:1").Select
Selection.Copy
Sheets("Sheet1").Select
Rows("1:1").Select
ActiveSheet.Paste
Sheets("Master").Select
Range("A1").Select
Cells.Find(What:="2", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
Rows("2:2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet2").Select
Rows("1:1").Select
ActiveSheet.Paste
Sheets("Master").Select
Range("A1").Select
Cells.Find(What:="3", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate
Rows("3:3").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Sheet3").Select
Rows("1:1").Select
ActiveSheet.Paste
End Sub
I find this is a great starting place. Have you tried this before?
David