Hi Tanya,
So I have 2 project level variables, both of type DBTable....
In Project properties, I can see that "TestDriver" has a default value of "{Worksheet: "AmritTest1"; workbook: "..\..\AmritTest1.xlsx"}"
While "ObjDefFile" has a default value of "{no table}". This is because I want to point ObjDefFile to a number of different files (could be XLS, or CSV, not yet made my mind up, but will always be the same filetype!) - and the path to this file will come from a value extracted as part of processing "TestDriver". So one of the columns in TestDriver might contain:
c:\file1.xls
c:\file2.xls
c:\file3.xls
As the script reads these different values, I need "ObjDefFile" to use the contents of these files for subsequent processing in the script. ie, ObjDefFile would need it's "default value" to change programmatically such as:
"{Worksheet: "localdata"; workbook: "c:\file1.xls"}"
"{Worksheet: "localdata"; workbook: "c:\file2.xls"}"
"{Worksheet: "localdata"; workbook: "c:\file3.xls"}"
Is this possible?
