KB31 - Why don't the VBS Sample Scripts run?

Description

The VBS samples do not run.

Solution

There can be many reasons for this:

1) Excel SpeedGen is not Installed

Normally the setup program should do this for you, but if not registering is easy. You simply need to run regsvr32.exe on the XLSpeedGen.dll

2) The .VBS Extension is not registered to WScript.exe

Open up your Folder Options, choose File Types and then assign it to wscript.exe (usually found in your System32 folder)

3) Anti-Virus Programs

Some Anti-Virus Software is very aggresive and will remove or disable all VBS files it finds. If you cannot find a way around it then you can always cut and paste the code from the VBS file into Visual Basic or a Microsoft Office Application's VBA Editor. If you can't find the VBS file then you can cut and paste from the html version in the Samples.

4) NT 4 Users

Ensure you have Windows Scripting Hosthttp://microsoft.com/msdownload/vbscript/scripting.asp installed.
Ensure you have the latest MDAC Drivershttp://www.microsoft.com/data/ installed. (or at least v2.1)