How do I create a VBScript multiline array?

I have a VBScript file that I use that has a lot of values in an array. recipes = Array("chicken soup","turkey","mash potatoes","yams","stuffing") What is the proper way to declare this array over multiple lines, something similar to this: recipe...
more »

2017-11-11 04:11 (4) Answers

Get Name of XML Column

I have an XML that looks like this: <data name='dat1'> <row name='row1'> <orange>blah</orange> <red>more blah</red> </row> </data> I am passing this XML through an HTTP post. On the dest...
more »

2017-10-24 21:10 (1) Answers

restart and login to remote windows

we have a requirement to run automation scripts on multiple machines, these scripts works on windows dialog box and other gui objects automation scripts are failing when windows logoff and as per security our machines logoff automatically i tried ...
more »

2017-08-08 15:08 (1) Answers

Split a XML into multiple XMLs

I am looking for a batch/VBScript which can split a large XML with multiple tags into multiple XML files. Please see details below. Input XML: <Shipment> ----some data- say 001------- </Shipment> < Shipment> ---- Some data- ...
more »

2017-07-08 16:07 (2) Answers

Parse Json string to Classic ASP page

What is the best way to parse json string into classic asp using a library? Dim jsonString jsonString = {"date":"4/28/2017","custType":"100","vehicle":"1"} Would like to have response.write("<li> date :" & json("date") & "</li>...
more »

2017-04-29 01:04 (1) Answers

SQL parameters not returning any results

Following code is not returning any results: search = "'%" & Request.QueryString("itemname") & "%'" Set cmd = Server.CreateObject("ADODB.COMMAND") Set cmd.ActiveConnection = conn sql = "" sql = sql & "DECLARE @search varchar;" sql = ...
more »

2017-04-26 00:04 (1) Answers

VBScript not handling Save As box correctly

I'm trying to write a VBScript to open and close an .xlsm file, which holds a macro that refreshes the file and saves a new copy. The macro within the .xlsm doc works fine when testing alone. When trying to open and close the file through the script...
more »

2017-04-13 17:04 (0) Answers

Output ADODB.RecordSet as JSON

I'm trying to change my application so that it outputs JSON instead of HTML when it makes an AJAX request for some data. I have an ADODB RecordSet. I need to loop through it row-by-row and add/change/remove different values. Then I need to take all t...
more »

2017-02-22 16:02 (3) Answers

VB save file in called script location

I am trying to create a script that will grab the computer system info of a network user that logs in and then put that info into a txt doc that I can use later to put them into a spreadsheet for inventory purposes. I have gotten the script to work ...
more »

2017-01-31 17:01 (0) Answers

How to get XML attribute value?

Set XmlDocument = Server.CreateObject("Msxml2.DOMDocument.3.0") XmlDocument.SetProperty "ServerHTTPRequest", True XmlDocument.Async = False XmlDocument.Load("books.xml") Set Items = XmlDocument.selectNodes("//book") For Each Item in Items Set tit...
more »

2017-01-08 18:01 (1) Answers

Append child in XML document using Classic ASP

I have the following asp-classic code which appends 3 variables into an XML document, 'location_x', 'location_y' and 'date_and_time'. The ASP-Classic code - creates or appends an existing XML document. Function LoadObjecttoXML(strXMLFilePath, strFi...
more »

2016-09-24 00:09 (1) Answers

How to delete XML comments

I wrote a VBScript to remove all the comments in a XML file. But it didn't work correctly. The script reads from a .xml file, generates a XML file which removes comments and another temp XML file. Set argus = WScript.Arguments If argus.Count = 0 The...
more »

2016-09-21 08:09 (2) Answers

Find and Edit Text File

I'm looking to find if there is a way of automating this process. Basically I have 300,000 rows of data needed to download on a daily basis. There are a couple of rows that need to be edited before it can be uploaded to SQL. Jordan || Michael | 23 |...
more »

2016-08-24 07:08 (2) Answers

Passing data from VBScript to XSL

I'm completely new to both VBScript and XSL manipulation, but am in a position where I need to do some work on such files... So there's a chance this might not even be possible, or that I'm misunderstanding how the current code works, or whatever. B...
more »

2016-07-26 12:07 (1) Answers

find replace vbscript excel specific cell

I want to make use of the find replace Vbscript function on a specific cell inside excel. My Current code is: Dim myxl Dim mywb Dim mysh Set myxl = CreateObject("Excel.Application") myxl.Visible = True myxl.DisplayAlerts = False myxl.EnableEvents ...
more »

2016-06-24 14:06 (1) Answers