PDA

View Full Version : outputing to excel


¿jobe¿
03-03-2001, 02:42 PM
Hello everyone,

I was wondering if you can use scripting to input some values and then send them to a spreadsheet in excel?

RWSchlatter
03-03-2001, 11:50 PM
sure, but Scripting input is a bit limited:

<pre>object.Interactive

Arguments
object
WScript object.

Remarks
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).

Example
The following JScript code displays the script mode.

WScript.Echo WScript.Interactive;
The following JScript code sets the script mode to batch.

WScript.Interactive = false;

See Also
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