Hi Simon,
You just need an input box.
Dim NewVar NewVar = InputBox("Enter a new variable.") If NewVar = "" Then Wscript.Echo("No variable entered - exiting...") Wscript.Quit End If ' Now just use NewVar in your script.
For reading in a csv file use the "Scripting.FileSystemObject".
http://www.microsoft.com/technet/scriptcenter/scripts/logs/text/lgtxvb01.mspx Is a sample of that for a DHCP log.
CreateWindow http://justpageprobe.com The FREE Web page utility you always wanted. Monitor your enterprise Web Servers. Keep your router connected. Email your IP to where you need it.
"Simon G" <SimonG[ at ]discussions.microsoft.com> wrote in message news:C4791E1E-23BE-4CB3-BA6A-816FDC5292DA[ at ]microsoft.com...
[Quoted Text] > This may not be in the right forum, but... > > I've got a nice little sql script which works fine, it has one variable > which i change quite frequently. > > Is it possible to have a vb script display me with a prompt box, i enter > the > new variable, it then puts that into my already working sql script and > queries the sql server and then simply returns the results? preferably as > a > csv file? > >
|