VBS syntax

  • Thread starter Thread starter Just Merks
  • Start date Start date
J

Just Merks

Hello,

Anyone knows a site which provides an overview of all VBS instructions
(examples) which can be used for writting macro's.

thanks,

Just
 
Hello,

Anyone knows a site which provides an overview of all VBS instructions
(examples) which can be used for writting macro's.

thanks,

Just
Click to expand...

Are you using Ability Spreadsheet? I think VBS is the macro language
of that SS. For Excel use VBA.

Lance
 
Hi,

I doubt there is any single site that shows examples of every single command
(method, object, function,...). The VBA help system is probably the most
complete you will find, but that doesn't mean its always the best.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
Gary said:
Are you using Ability Spreadsheet? I think VBS is the macro language
of that SS. For Excel use VBA.

Lance
Click to expand...

As a side note, "vbs" might also mean Microsoft Visual Basic Scripting
Edition.

Here's a very simple example how I might use it.
A backup program runs at a certain time each night. It could be
anything for that matter.

In NotePad, I will type the following short statement...

MsgBox "Notice: Backup to start soon!"

Save this with an extension "VBS." ie "MsgBackup.VBS"

If you double click this file, the msgbox will pop up.

I will then set up a "Schedule" to run this program about 10 minutes
prior to the Backup program running. When the msgbox pops up on the
screen, it reminds me to make sure the backup device is plugged in,
turned on, and to perhaps finish up any work.

- -
Dana DeLouis
 
Back
Top