vbscript

How to list all WMI classes having methods using VBScript?

Using VBScript, how can I list all WMI classes that have methods? Thanks in advance. ...

Looking for some ideas on how to create a graph from a sql table and output it to a webpage

I am familiar with vbscript, I am looking for a few ideas on how to do this. I am open to trying other scripting languages. The graph does not have to be incredibly fancy. Any suggestions would be greatly appreciated. ...

Return a vbscript regex match on multilines

I am using vbscript regex to find self-defined tags within a file. "\[\$[\s,\S]*\$\]" Unfortunately, I am doing something wrong, so it will grab all of the text between two different tags. I know this is caused by not excluding "$]" between the pre and post tag, but I can't seem to find the right way to fix this. For example: [$Stri...

VBScript Converting XML Data to an ADODB RecordSet

I have a situation in which I need to dump XML into an ADODB Recordset in VBScript. My XML is in the form below. What I would like to do in my code is convert the XML into a recordset with AddressObject rows. The code below I tried but keep running into one DomDocument error after another. Can anyone please help me with a solution for th...

Checking IE Window Status of a Manually opened IE Window

HI all, I am trying to script some actions on a web based application by using simple SendKeys in a .VBS script. The only problem i have come accross is the fact that i have to put Sleeps in the script to wait for pages loading. I was wondering if there was a was i could monitor an IT window and wait for it to finish loading instead o...

Help passing XML String to RecordSet

What I would like to do is dump an XML String into RecordSet. The problem I am having is that the code seems to work fine if I saved the XML String first to a file and then read from the file which I think is redundant. However, when I want to read from string, I get the error RecordSet cannot be created. Source XML is incomplete or in...

Cancel fax in vbscript

I can't find a way to do this anywhere, not even a mention of it. But is there is a way to programmatically cancel a fax using, say, a faxserver or faxdocument object? My current code looks something like this: Set doc=CreateObject("FaxComEx.FaxDocument") Set server=CreateObject("FaxComEx.FaxServer") server.Connect "" doc.Body="c:\som...

How can I convert a string array to a variant array in VBscript?

I'm using a function in vbscript which returns a variant array of strings. JobIDs = objDoc.ConnectedSubmit(objServer) The problem is I can't get the Job ID values from that array, as vbscript doesn't handle typed variables. It just gives a type mismatch when I attempt to do ANYTHING with the JobIDs array. I found some promising info...

Manipulating Access VBIDE from VBScript

I'm trying to write a vbscript that will export and import the code modules from an Access MDB file to text files. From within the app I can loop through the DAO Container & Documents and use the 'undocumented' Application.SaveAsText method, but can I do it exeternally? Your thoughts and ideas are appreciated. Ben ...

How to export all tables from an Access Database into Excel - A sheet for each table...

I have an Access database with ~30 tables. How can I export all 30 tables into separate sheets in an Excel workbook? I'm hoping to find some VBA/VBS code which I can run from within Access to accomplish this task. Any ideas? ...

How to pause a vbscript execution?

How can I pause an execution of a script from within? Something like Sleep WinAPI function? ...

Embed VBScript inside Windows batch file

Is it possible to embed VBScript within a batch file? I currently have a .CMD file that calls a .VBS file using cscript //NoLogo MyScript.vbs but I'd prefer to distribute just a single .CMD file. ...

Can a VBScript function return a dictionary?

I have a dictionary of form data that I want to modify using a function. function queryCleanForm(myDictForm) dim arrayKeys arrayKeys = myDictForm.keys for i=0 to myDictForm.count-1 myDictForm(arrayKeys(i)) = replace(myDictForm(arrayKeys(i)), "'", "''") response.write myDictForm(arrayKeys(i)) next q...

ADO Persistent XML to RecordSet Problem

I need to Convert my XML Data to an ADO RecordSet. I am able to construct the ADO Persistant XML format for the conversion but I am not too sure why the single row in my XML is being ignored. The final recordset produced has EOF and BOF both as true, and RecordCount is 0 but that is incorrect since my XML does contain at one row as in th...

VBScript: Trim characters from left of folder names

Hello, I would like to trim an x amount of characters from the left of multiple folders. Imagine having these folder names: 01.a-foldername 02.b-foldername 03.c-foldername After being processed by the VBscript they become: a-foldername b-foldername c-foldername ...

Import txt file from web form to sqlserver database using vbscript

Hi, I have been asked to build a web application to report on information stored in another system. The other system is locked down but will allow me to export data as a csv file. I'd like to use an html form on my application so that people (the night shift!) can import data from the other system to my web application. To allow oth...

Problems with xmlhttp

I have the following code to grab details from a webserver <%@ LANGUAGE=VBScript%> <% vCustomerUserName = "name" vCustomerPassword = "password" vEventID = 123456 vEmail = "[email protected]" vPassword = "1122334455" Response.Buffer=False Dim MyConnection Dim TheURL ''# Specifying the URL dataURL = "http://www.regonline.com/authorization...

Search for string using VBscript and copy that column to another worksheet

I have Book1.csv and Book2.xlsx. Book1.csv has many columns with data. Each column has unique title in first ROW. I need to find column with title “Processor Time” and copy all available data in this column to column1 in Book2.xlsx using VBscript. Please help. ...

VBScript - Regular Expression replace spaces

I have a situation where using VBScript I need to check for the presence of multiple spaces. I want to check for the presence of 2 or more consecutive spaces, so \s+ doesnt work for my needs. Does anyone know how I can accomplish this using VBScript regular expressions. ...

Debugger on wrong line when debugging Classic Asp

I'm having trouble debugging any ASP Classic website on my workstation using any of the MS debugging environments available to me. I'm on Win XP SP3, using the builtin IIS 5.1. It started a few weeks ago, and happens across multiple projects. Something clearly changed in my environment, because it was working fine in the past, even in r...