ou_ryperd
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Re: How to put value in Table (Variables)
Is it possible to retrieve a value from the table as can be done in VBScript with: set dict = CreateObject("Scripting.Dictionary") dict.add "Italy", "Rome" dict.add "Germany", "Berlin" msgbox dict.item("Italy") -> returns "Rome" e.g. Dim t If Not Project.Variables.VariableExists("MyTable") Then Call Project.Variables.AddVariable("MyTable", "Table") End If Set t = Project.Variables.VariableByName("MyTable") Call t.AddColumn("Name") Call t.AddColumn("Age") Call t.AddColumn("City") t.RowCount = 2 t.Name(0) = "John Smith" t.Age(0) = 24 t.City(0) = "Seattle" t.Item("Name", 1) = "Bob Feather" t.Item("Age", 1) = 59 t.Item("City", 1) = "Milltown" msgbox t.item("City", "Name" = "Bob Feather") <- I want the City where the Name is Bob Feather How to do this ?4.9KViews1like1Comment