The VBScript Network and Systems Administrator's Cafe:

May, 2008

1

May 26, 2008  3:48 PM

VBScript Statements: Explanation of the Option Explicit Statement

Jerry Lees Jerry Lees Profile: Jerry Lees

In VBScript declaring your variables up front is not required (as stated in this sites explanation of the Dim Statement), however, many programmers choose to declare their variables up front to avoid having to track down misspellings in their code. They go further by adding the Option...

May 24, 2008  3:47 PM

VBScript Statements: Explanation of the Dim Statement

Jerry Lees Jerry Lees Profile: Jerry Lees

The DIM statement is used to declare variables prior to being used. To save space in your code, you can declare more than one variable in a single statement by separating each variable with a comma. For example: Dim x Dim x, y, z The Dim...


May 23, 2008  8:00 PM

VBScript Statements: Explanation of the Const Statement

Jerry Lees Jerry Lees Profile: Jerry Lees

The Const statement is useful when you want to reference a specific, unchanging, value in your code multiple times without typing it over and over. For example, in order to use the Const Statement to create a reference to the value of pi to 50 decimal places, you use...


May 23, 2008  2:39 PM

Sending e-mails with VBScript using the cdo.sys object

Jerry Lees Jerry Lees Profile: Jerry Lees

Writing text files, Word docs, Excel spreadsheets with VBScript is great and all-- but sometimes you just need a process to run and notify you when something happens. (Without remembering to check a file every day.) In fact, sometimes it's nice to walk in and receive an email in your inbox...


May 21, 2008  6:49 PM

VBScript Statements: Explanation of If… Then … Endif

Jerry Lees Jerry Lees Profile: Jerry Lees

The If/Then/Else statement in VBScript is very similar to the Select Case statement, except it only normally allows for 2 possibilities in your condition. ...


May 14, 2008  8:58 PM

Getting disk usage data with the filesystem object and the Excel.Application object in VBScript

Jerry Lees Jerry Lees Profile: Jerry Lees

In my previous posting, entitled

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 9, 2008  5:54 PM

VBScript Statements: Explanation of Select … Case

Jerry Lees Jerry Lees Profile: Jerry Lees

The Select ... Case VBScript statement is a very powerful way to easily preform specific actions based on a comparison of a variable to a series of cases you specify, plus it allows for the fact that NONE of the cases apply with an optional case else...


May 9, 2008  4:28 PM

Working with the Excel.Application object in VBScript to create Excel Spreadsheets

Jerry Lees Jerry Lees Profile: Jerry Lees

In my previous two postings we discussed the Microsoft Word.Application object (here and

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


May 2, 2008  4:15 PM

Document group policy objects in Microsoft Word using VBScript

Jerry Lees Jerry Lees Profile: Jerry Lees

OK, here is the posting I hinted at in my previous posting this week entitled,

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: