I am using Set of Variables in different functions
in the main script.
i dont want to pass them to each Function
Main script i am reading variable from Excel Sheet
In Lib Files i have Written Funcations
Here's one way to make an environment variable
MyVariable = DataTable("MyVariable",dtLocalSheet)
Environment("MyVariable") = MyVariable
Patience is like bread I say.... I ran out of that yesterday.
yes i am reading them from excel sheet once
once i have read them i donot want to
pass to each and every funcation i want them to be available to all the functions without passing them
let me give some example
Say there are two funcation which are in followin format
forget about other parameters to function other than a,b
a,b used in above two functions are same values
I have read values a,b from excel sheet
and got into into Global data sheet while running
once i do that
i donot want to pass a and b to each function , in out example MyFun1,MYFun2
i want to make those variable avalible to the funcations with out passing them to them
How do we do that
sorry the First function in above pos is
See if this helps....
Public TestVar : TestVar = 10
Public Function Test1()
TestVar = TestVar+10
Public Function Test2()
will this work if the function are called from main script are coded in the Libriry files
To make it work globally, you need to keep the public variable declaration part in a vbs file and assign that to test settings.