Search found 14543 matches

by jvierra
Sun Jul 08, 2007 3:06 am
Forum: VBScript
Topic: CScript vs WScript
Replies: 14
Views: 15379

CScript vs WScript

shell.run "cscript.exe """ & Wscript.ScriptFullName & """", 0 , true No window and wait for execution to end. To override execution environment defaults settings use command line switches with "cscript". CSCRIPT //NOLOGO //B ... etc. Type cscript /? at prompt for all options. Don't use the //H optio...
by jvierra
Fri Jul 06, 2007 2:46 pm
Forum: VBScript
Topic: MS Access SQL Query script
Replies: 13
Views: 9417

MS Access SQL Query script

You have to have MSAccess installed on the machione you are running this on.
by jvierra
Fri Jul 06, 2007 8:37 am
Forum: VBScript
Topic: MS Access SQL Query script
Replies: 13
Views: 9417

MS Access SQL Query script

YOu need to read something about how to write a script. YOu have the function inline but you are not calling it. I suggest getting some basic informatipon about scripting before you continue. Got to this link and study the material. It will help you see what you have missed I believe. http://www.scr...
by jvierra
Fri Jul 06, 2007 6:52 am
Forum: VBScript
Topic: SendKeys WindowsKey ?
Replies: 1
Views: 3681

SendKeys WindowsKey ?

Generally teh "Windows" key is mapped to shell functions. Look into using direct calls to teh shell methods for things like "LogOff" and other menu and utility functions.

by jvierra
Fri Jul 06, 2007 6:39 am
Forum: VBScript
Topic: MS Access SQL Query script
Replies: 13
Views: 9417

MS Access SQL Query script

Look into the "Export methods. TransferSpreadsheet and the others like it. Sub ExportToExcel(filename, queryname)     App.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, queryname, filename, True End Sub For the above you either need to make the "App" object global to the file or only u...
by jvierra
Fri Jul 06, 2007 6:16 am
Forum: Other Scripting Languages
Topic: Perfmon monitoring through ActiveX
Replies: 2
Views: 4348

Perfmon monitoring through ActiveX

You cannot do this remotely due to security restrictions on servers. Place the HTML definition file in a shared folder and give users access. I don't recommend this as multiple users can create an extra load for the server. To share perf data define a data capture monitor and have it roll every 30 m...
by jvierra
Fri Jul 06, 2007 6:09 am
Forum: VBScript
Topic: MS Access SQL Query script
Replies: 13
Views: 9417

MS Access SQL Query script

If yo are looking to provide web based management reporting I highly recommend Microsofts Report Server. It can automate most of the taks needed for deliverng data from a query in multiple formats including CSV, Excel, XML and PDF. Just define your query and use one of teh sqample templates and you ...
by jvierra
Fri Jul 06, 2007 5:09 am
Forum: VBScript
Topic: MS Access SQL Query script
Replies: 13
Views: 9417

MS Access SQL Query script

Here is a simple bootstrap for creating a new database from vbs:     sPath = "E:ProjectsscriptsMSAccess"     sDBName = "MyDB.mdb"     dbLangGeneral = ";LANGID=0x0409;CP=1252;COUNTRY=0"     Dim app As Access.Application     Set app = CreateObject("Access.Application")             ' create a new datab...
by jvierra
Fri Jul 06, 2007 3:54 am
Forum: VBScript
Topic: MS Access SQL Query script
Replies: 13
Views: 9417

MS Access SQL Query script

Suggestion: Create a template database using MSAccess. Place query in template file. Make a copy of the template to a new name and inject the data into a pre-existing table or tables that the query will use. You can also automate teh whole reporting process in MSAccess and just use data from an exte...
by jvierra
Fri Jun 29, 2007 6:56 am
Forum: VBScript
Topic: Reading in multipule line text via StdIn
Replies: 6
Views: 4248

Reading in multipule line text via StdIn

Great - glad to help. That one threw me fo a loop when reading in unicode files. That's when I found the KB and tested the incremental read method.

Your should work woth readline and a Ctrl-Z except if you are MUI.