Hi,
in a post below I asked how to read an environment var, now I need to write to one.
I'm building a VBS/VBA app that calls a predefined progress program. I feed it parameters using environment vars like "fromdate" "todate" "outputfile" but now I need progress to signal back to windows that it is done outputting, so I want my last line in progress to be something like this :
Could someone provide me a simple cut and paste example of both?
I'm new to progress, an admin that needs to do some datamining.
thx for any help
Freneksi
in a post below I asked how to read an environment var, now I need to write to one.
I'm building a VBS/VBA app that calls a predefined progress program. I feed it parameters using environment vars like "fromdate" "todate" "outputfile" but now I need progress to signal back to windows that it is done outputting, so I want my last line in progress to be something like this :
os-setenv("busy", 0) /*this command doesn't exist*/
and then wait for it to happen in vbs using :
while shell.environment.item("busy") <> 0
sleep 100
wend
excel.Workbooks.OpenText outputfile ....
Maybe I should look into reading and writing the registry? sleep 100
wend
excel.Workbooks.OpenText outputfile ....
Could someone provide me a simple cut and paste example of both?
I'm new to progress, an admin that needs to do some datamining.
thx for any help
Freneksi