Printable View
Hi all,
To get straight to the point, Is it possible for me to create a static variable with vbs??
When I do this with VBA,
[VBA]
Static tnow
tnow = Time + TimeSerial(0, 1, 0)
Do Until Time > tnow
MsgBox Time
Loop[/VBA]
Fine, it works, but in vbs I get an error. I therefore suspect the use of Static is not allowed in vbs. If this is the case, how can I get round this??
Many thanks in advance.
I tried your snippet in a VB6 form, and it ran without error.
Indeed, but I'm only concerned with VBS not VB6 !!Quote:
I tried your snippet in a VB6 form
There is no Static declaration in VBS and yes there is in VBA and VB 6, thats why it works on both.
I recommend you to check this site http://www.sunny-beach.net/manual/249.htm for differences between VB, VBA and VBScript.
Ok, thanks Carlos. I suspected this.
So, how do I get round this??
Any suggestions folks??
Hi,
just take the static off. You may use this:
HTML Code:<html>
<head>
<script language="VBScript">
Sub Test
tnow = Time + TimeSerial(0, 1, 0)
Do Until Time > tnow
MsgBox Time
Loop
End Sub
</script>
</head>
<body onload="Test">
Tested!
</body>
</html>
Thanks my friend, sorry for the delay in getting back. Spun off in an Excel charts whirlwind!!
You are welcome and thanks for the help on my post!:thumb