03-03-2001, 02:42 PM
I was wondering if you can use scripting to input some values and then send them to a spreadsheet in excel?
03-03-2001, 11:50 PM
sure, but Scripting input is a bit limited:
The Interactive Property returns a Boolean value.
There are two modes: batch and interactive. In interactive mode (the default), the script
provides user interaction. Input to and output from the Windows Script Host is enabled.
The script can echo information to dialog boxes, and can wait for the user to provide
feedback. In batch mode, this type of user interaction is not supported – all input and
output to WSH is disabled. You can also set the script mode using the Windows
Script Host command line switches //I (for Interactive), and //B (for Batch).
The following JScript code displays the script mode.
The following JScript code sets the script mode to batch.
WScript.Interactive = false;
WScript Object</pre>copied from Microsoft Help file
from this input, write an output stream to a (text) file in CSV (comma separated variables).
Regards - Richard