VBS Functions
The lack of a decent GUI for VBS development has always been a problem for most people. The advantages of using VBS are great, but writing the scripts can be labourious, especially if you don’t have a lot of experience and know all the commands/functions etc. Nowadays, there are plenty of 3rd-party development environments available now, in fact, I use the excellent VBSEdit as it has code completion and comes with a whole load of code snippets covering all sorts of areas. The code completion feature is super helpful, especially when trying to remember the syntax of a particular function.
For reference purposes, I have included below a list of all the VBS functions as I am always looking up this information, so I thought I’d post it here so that it is more accessible to everyone (including me).
Abs |
Returns the absolute value of a number. Wscript.Echo(Abs(-5)). returns: 5 |
Asc |
Returns the ASCII character code for the first character of a string. Wscript.Echo(ASC ("ABC")). returns: 65 |
Chr |
Returns the corresponding character of passed ASCII code number. Wscript.Echo(Chr(65)). returns: A |
Cos |
Returns cosine value of a number. Wscript.Echo(Cos(1)). returns: 0.54030230586814 |
Date |
Returns the current system date in month, day, year format. Wscript.Echo(date()). returns: 8/2/02 ->with current date |
DateAdd |
Adds the specified date or time value to specified date. Wscript.Echo(DateAdd("d","10","6-7-02")). returns: 6/17/02 -> Adds 10 days to specified date. d=day, m=month, y=year, h=hour, n=minute |
Day |
Returns the day of the month. Wscript.Echo(Day(date)). returns: 9 ->with current day number. |
Fix |
Returns the integer part of a number. Wscript.Echo(fix(5.567)). returns: 5 |
FormatCurrency |
Returns an expression formatted as a currency value. Wscript.Echo(FormatCurrency(10.888)). returns: $10.89 |
FormatDateTime |
Returns a formatted date or time. Wscript.Echo(FormatDateTime(date)). returns: 8/2/02-> with current date. |
FormatNumber |
Returns an expression formatted as a number value. Wscript.Echo(FormatNumber(1000.1111,2)). returns: 1,000.11 |
FormatPercent |
Returns an expression formatted as a percent Wscript.Echo(FormatPercent(.22)). returns: 22.00% |
Hex |
Returns the hexadecimal value of a number. Wscript.Echo(Hex(10)). returns: A |
Hour, Minute, Second |
Returns the number representing hour, minute, second of the day, hour, or minute. Wscript.Echo(Hour()). returns: 11 -> Assuming it's the hour is 11. |
Int |
Returns the integer part of a number. Wscript.Echo(Int(5.567)). returns: 5 |
IsNumeric |
Returns Boolean value [true or false] indicates whether is number or not. Wscript.Echo(IsNumeric(10.888)). returns: True |
LCase |
Converts all the characters to lowercase. Wscript.Echo(LCase("CASE")). returns: case |
Left |
Returns specified number of characters starting from left. Wscript.Echo(left("language",3)). returns: lan |
LTrim |
Removes all the leading spaces from the string. Wscript.Echo(LTrim("far ")). returns: far, with no spaces |
Month |
Returns the month of the year. Wscript.Echo(Month(date)). returns: 9 ->with current month number. |
MonthName |
Returns the name of the specified month. Wscript.Echo(MonthName(9)). returns: September |
MsgBox |
Returns dialog box with specified expression or arguments. msgbox"Hello World" returns: Hello World -> On dialog box. |
Now() |
Returns current system date and time. Wscript.Echo(now()). returns: 8/2/02 10:46:33 AM ->with current date & time |
Right |
Returns specified number of characters staring from right. Wscript.Echo(Right("language")). returns: age |
Rnd |
Returns random number. Wscript.Echo(Rnd). returns: 0.7055475 ->Needs some code to randomize. |
Round |
Returns rounded number. Wscript.Echo(Round(10.888)). returns: 11 |
RTrim |
Removes all the trailing spaces from the string. Wscript.Echo(RTrim(" far")). returns: far, with no spaces |
Sgn |
Returns 1, 0, or -1 for positive, zero or negative number Wscript.Echo(Sgn(-22)). returns: -1 |
Sin |
Returns sine value of a number. Wscript.Echo(sin(1)). returns: 0.841470984807897 |
Sqr |
Returns square root of a number. Wscript.Echo(sqr(25)). returns: 5 |
String |
Takes a number and character code argument and returns the character, repeated a number of times: Wscript.Echo(String(3,80)). returns: BBB |
Tan |
Returns tangent value of a number. Wscript.Echo(tan(1)). returns: 1.5574077246549 |
Time |
Returns the current system time. Wscript.Echo(Time()). returns: 10:11:36 AM ->with current time. |
Timer |
Returns the number of seconds since 12:00 AM. Wscript.Echo(Timer). returns: 40055.84 -> at 11:07 AM |
TimeSerial |
Returns the time for a specific hour, minute, and second converted from military clock. Wscript.Echo(TimeSerial(17,30,05)). returns: 5:30:05 PM. |
TimeValue(time) |
Returns the current system time. Wscript.Echo(Time(time))returns: 11:18:00 AM -> with current time. |
Trim |
Returns the string argument, with leading and trailing spaced removed. Wscript.Echo(Trim(" mid ")). returns: mid, with no spaces. |
UCase |
Converts all the characters to upper case. Wscript.Echo(UCase("Case")). returns: CASE |
Val |
Returns number value of a string. Stops as soon it hits string char. Wscript.Echo(Val("22 Maple st.")). returns: 22 |
WeekDay |
Returns number representing the day of the week. Wscript.Echo(WeekDay(date)). returns: 6 -> Assuming today is Friday |
WeekdayName |
Returns the name of the specified week day. Wscript.Echo(WeekdayName(6)). returns: Friday |
These functions are built-in to VBS so all you need to do is pass the correct values! I can’t remember where I sourced all of this information from, so if you want to be credited, just let me know!
Comments
Anonymous
April 14, 2009
Thanks, i am always having to look this up as well. you are the best!Anonymous
November 25, 2009
Thanks, nice blog and useful tips & tools, you're still #1