Home » Forums » Open Source Learning Center » Question and Answer

Date function . VBE

Submitted by ruth on 15 December, 2012 - 05:37

Hi all ,

I dont want to run this particular script, if the system date crossed 24/12/2012.

Any suggestions, what date function should i add in this script which will check the date = 24/12/2012 and will exit the script.
...................................................
Set wshShell = wscript.CreateObject("WScript.Shell")

msgbox("Hello")
....................................................

Please note this is a notepad made .vbe file script.

Thanks
Ruth

‹ Copy - paste between desktop excel file and web embedded excel table Multiple rows returned from a vlookup ›
»

If Int(Now()) > 24 / 12 /

Submitted by AndyLitch on 15 December, 2012 - 15:56.

If Int(Now()) > 24 / 12 / 2012 Then Exit Sub

»

Need Exact syntax for WSH or .VBE

Submitted by ruth on 16 December, 2012 - 12:27.

Hi,
Thank you,but the code/systax you provided, seems is for VBA or EXCEL as it is not perhaps working for .vbe(WSH) ?Can you change it to be compatible for .vbe extention.
Sorry for being DUMB but i m new to these syntaxes.

Regards
Ruth

»