I don't want to send you barking up the wrong tree but here is some basic
info on VBScript.
VBScript is a MS Scripting language that is simple to use (a bit like Basic
in the old days, and quite like
VB).
Scripts are text fiules that can run from
a. inside HTML pages (like JavaScript) or from (.hta pages )
b. the DOS command line
c. from Windows explorer, doubleclick on a .vbs file and it will run - if
the wscript engine is enabled
There's lot's of info on what it can do on different sites, Google can find
you all that.
There is a chm help file that is the standard manual and it's full of code
snippets that you van copy and paste into your own script files.
Script files have a .vbs extension.You may already have some on your
machine. Right click and Modify to read before you run !
They can do some pretty powerful things and be quite dangerous when they
interact with the WMI. Windows Management Interface.
You can download and install the engine for free from Microsoft
I find it very useful for manipulating text files and data within text
files.
But
It has practically no interface. Just an input fileld and no communication
with the user except basic message boxes and output files.
You can add an interface by embeding the script in an HTML file with buttons
and bells and renaming the htm extension to hta.
Hta files have access to the File System with the same rights as the session
user.
And then there is a MS site where a bunch of crazies called the MS
Scriptomatic team tell you how to do all sorts of things to remotes
computers too.
If you can handle VBA, you can VBScript. And VBScript can access the Excel
application as an Object and manipulate all of its objects.
Workbooks,.Sheets, Cells, but that's another level.
If you just need data manipulation within text files why not give it a
blast.
Erasmus
http://msdn.microsoft.com/library/de...scriptinga.asp
"DHallam" a écrit
dans le message de news:
...
Hi, What is the format of this code then? What is VBScript? and is there
a big difference between the script?
--
DHallam
------------------------------------------------------------------------
DHallam's Profile:
http://www.excelforum.com/member.php...o&userid=25253
View this thread: http://www.excelforum.com/showthread...hreadid=388303