{ From user Lonnie, Model SpreadsheetProperty1 at 19-Oct-2012 2:42:51 PM }
SoftwareVersion 4.4.4


{ System Variables with non-default values: }
TypeChecking := 1
Checking := 1
SaveOptions := 2
SaveValues := 0




Model SpreadsheetProperty1
Author: Lonnie
Date: Thu, Oct 18, 2012 4:30 PM
SaveAuthor: Lonnie
SaveDate: Fri, Oct 19, 2012 2:42 PM
DiagState: 2,1,0,899,593,17
FontStyle: Arial,15
FileInfo: 0,Model SpreadsheetProperty1,2,2,0,0,W:\Testmodels\SpreadsheetProperty.ana

Variable wb
Title: wb
Definition: spreadsheetOpen("13116.xlsx" )
NodeLocation: 120,64,1
NodeSize: 48,24

Variable Property_value
Title: Property value
Definition: reset; ~
spreadsheetInfo(wb,Property )~

NodeLocation: 288,72,1
NodeSize: 48,24
ValueState: 2,482,436,771,382,0,MIDM

Variable Property
Title: Property
Definition: ["Filename",'Author','Name','Title','Date1904','ReadOnly','Saved','CodeName','ActiveSheet','AcceptLabelsInFormulas','CalculationMode','SelectedRange','SelectedRangeR1C1']
NodeLocation: 120,144,1
NodeSize: 48,24

Button Refresh
Title: Refresh
NodeLocation: 488,64,1
NodeSize: 48,24
Script: (reset := reset + 1)~
Property_value~
show result property_value

Variable reset
Title: reset
Definition: 7
NodeLocation: 120,224,1
NodeSize: 48,24

Variable Names
Title: Names
Definition: SpreadsheetInfo(wb,"Names"  )
NodeLocation: 304,208,1
NodeSize: 48,24
ValueState: 2,621,91,416,303,0,MIDM

Variable Sheets
Title: Sheets
Definition: SpreadsheetInfo(wb,"Sheets"  )
NodeLocation: 312,280,1
NodeSize: 48,24
ValueState: 2,621,91,416,303,0,MIDM

Variable Va1
Definition: spreadsheetSetInfo(wb,"CalculationMode","Auto")
NodeLocation: 432,280,1
NodeSize: 48,24

Variable set_author
Title: set author
Definition: SpreadsheetSetInfo(wb,"Author","Lonnie D")
NodeLocation: 432,360,1
NodeSize: 48,24

Variable Set_title
Title: Set title
Definition: SpreadsheetSetInfo(wb,"Title","My title")
NodeLocation: 552,352,1
NodeSize: 48,24

Variable Select_range
Title: Select range
Definition: SpreadsheetSetInfo(wb,"SelectedRange","EFR" )
NodeLocation: 432,448,1
NodeSize: 48,24

Close SpreadsheetProperty1