Microsoft's Visual Basic Scripting runtime. Use this tag for reviews of code written in vbScript.
4
votes
0answers
40 views
Counting instances of a string in a binary / unicode file using regex
(Originally posted on Stack Overflow)
I need to run through a number of bespoke files (I'm unsure if they are unicode / ascii or binary so have attached a snapshot through notepad++). I'd like to ...
4
votes
1answer
81 views
Web scraping VBA and VB Script
I am working on a project on VBA where the objective is to have a "program" that fetches rates from a website called X-Rates, and outputs to excel the monthly averages of a chosen country.
Initially ...
4
votes
1answer
67 views
Making a script file to perform maintenance
I wish to make a file to click on to do the 'usual' tasks I would do to clean/perform maintenance on my mother's computer when I'm not present. I made a script file and took a few command lines from ...
1
vote
0answers
26 views
Command line VBScript spam bot
I have made a simple program that, given a string and how many times to repeat it, it waits a second and types that string N times, followed by an enter key. It is made for applications like skype. ...
5
votes
1answer
43 views
Loading text into an array when fields are in random order
This script reads records from a CSV file of customer names and addresses. The first record of the file is the header (field names); the fields could be in any order, and sometimes have different ...
2
votes
0answers
48 views
VBscript XLS-to-CSV with minor transform
I have a system that only outputs reports in Excel 97-2003, and a second system (for the user to look at) that only accepts these reports in CSV format. The reports manager was previously opening ...
0
votes
0answers
34 views
On error : should the code be indented?
I did add an error management to a XML reading function(in hp-uft, a dialect of VBscript for automated tests), to avoid an unreadable error if the variable looked for is not found in the file.
...
8
votes
3answers
570 views
Login using VBScript
I was tasked with re-writing a login VBScript we use on about 50 machines. The original script was hacked together by someone who clearly had no idea what they were doing (multiple lines that ...
8
votes
1answer
2k views
PowerShell within HTA
I've put some code together that helps me search an internal ticket system using an HTA application with some TextBoxes and some embedded VBScript that runs PowerShell scripts. The PowerShell scripts ...
3
votes
1answer
241 views
Checking if a remote server is online
I have this vbs file to check if a remote server is accessible. Can I simplify or refactor to make it more robust/efficient?
...
4
votes
1answer
94 views
Proper capitalization for surname like McDonald
I am using the code below to capitalize a string properly. I would like to know if there is a better way to code the surname portion, as the way it stands now can become very bloated depending on how ...
3
votes
2answers
280 views
Capitalize string except for conjunction words
I am using the code below to capitalize words in a string. I do not want conjunction words capitalized, but always want the first character in the string to be capitalized no matter what the word is. ...
4
votes
2answers
218 views
Still pulling information from XML to insert into Word Document inside 3rd party application
Follow up to This Question
I took some very good advice and changed my code around a little bit and eliminated some If statements.
I am not retrieving very much ...
6
votes
1answer
70 views
Pulling information from XML to insert into Word Document inside 3rd party application
This is code written for use inside a 3rd party application to pull information from an XML and insert into a word document, I don't know all the mechanics of the fun process of inserting the ...
5
votes
2answers
93 views
Extracting information and returning specific data
The purpose of this code is to return an address for one of the seven judicial circuits for the cases that is passed into the function.
I am taking a Node ID, which is a 3-digit number the circuit ...
2
votes
2answers
277 views
pulling specific data from XML from inside 3rd party application
Another script that is used as a token to extract information from a 3rd party application, the application does other things in the background that I don't specifically know about.
This code does ...
4
votes
1answer
271 views
My script is about as scary as the XML it's reading
This was a revision, made when the code failed after an update (at least that is what I think happened).
So I fixed it and now it works, but I think that this code can be written better and more ...
7
votes
1answer
1k views
Extracting data from a Word document is too slow
I have a 100page long .docx format document. I'm using a macro written in VBS to extract some information and then just generate a table from them. I iterate through the paragraphs and store the ...
4
votes
1answer
180 views
VBScript for AD account creation
Does the following code look okay? Want to see if anyone can spot any mistakes I may have made. This will be pulling from a pre-formatted Excel document - I have already specified all needed Cell ...
5
votes
2answers
157 views
4
votes
1answer
64 views
Power utility for starting processes
I was looking for a way to start elevated (i.e. administrator permissions) and/or invisible processes via batch in Windows. It turns out that this is kind of impossible with batch only, so I googled ...
6
votes
2answers
1k views
VbScript/ASP Classic good OOP Pattern
I have to create a website in Classic ASP, and I really want to do a clean design so I will try to put everything in Classes and Models to emulate the ViewModel Pattern.
So can you tell me if this ...
7
votes
2answers
1k views
Check if an XML file exists then change URLs in it
This is my first VBScript I have ever written and I would like to know if there is any obvious blunders in the code. All the code should do is check if file exists then change the Yahoo URL to the ...
7
votes
2answers
1k views
Is there a more efficient way to do Base 32 encoding/decoding than this?
This journey started with a quest to create the shortest possible case-insensitive verification number. Based on the answers there, I worked out a Classic ASP/VBScript implementation of Crockford's ...
3
votes
3answers
301 views
Trying to speed up a report that takes freaking forever
I'll try to keep this as short as I can without losing context - we have a system for online education, where presentations often have a test.
Management has access to a report used for measuring ...
