Questions tagged [vbscript]
VBScript is Microsoft's Visual Basic Scripting runtime.
35
questions
4
votes
1
answer
100
views
Python SQL insert to MSAccess with VBScript
I have a business use case that required running SQL insert queries to a local MSAccess database with a Python script. The actual script does many other things and the SQL function is just one of them,...
1
vote
0
answers
265
views
A big prank using VBScript
So, I have made a BIG prank in VBScript.
First part is to prank with a Dummy HTA splash screen using an encoded PNG image inside it (Not included) and kill all windowed processes+explorer and keep it ...
5
votes
3
answers
108
views
Right-trimming text files
below vbscript code took me 3hours just to complete trimming whitespaces of a 24MB file any tips to speed up the process below?
...
4
votes
0
answers
132
views
Playing music in the background while another task is running
Sometimes some tasks can be taken a lot of time to end up.
This code is created in order to play a random radio music in background while the script is running another task until to finish up and the ...
5
votes
0
answers
1k
views
Multithreaded Excel + VBScript Timer: Snake Game Demo
Multithreaded Excel + VBScript Timer
After reviewing these post: Snake in Excel in… VBA? and Drawing a snake using arrow keys in Excel using VBA, I decided to work on creating a VBA Timer.
The ...
2
votes
0
answers
27
views
Store history data using customization features of a profesionnal software
Context
My company uses a system that has access to the state of different items in the plant.
This software can be customized, by executing a single VBScript function, at a given interval.
The ...
3
votes
2
answers
331
views
Comparison of excel files, cell by cell
below is the code that i created as a POC towards an implementation for 2 excel file comparison (cell by cell)
This was just to test the logic, which works as expected, however i found out that for ...
4
votes
0
answers
490
views
Recursive function to compare XML files using MSXML DOM
I have put together this function which compares two XMLs. On debugging, I found out that there are lot of useless loops which might cause performance problems for me if the files to compare are very ...
7
votes
0
answers
120
views
Script for gathering information on computers getting stolen
I have put together a small VBScript to gather a bunch of information and email at scheduled intervals, so that one day, should it happen, and my computers are stolen, I may be able to provide ...
2
votes
1
answer
1k
views
VBs to query AD
I'm trying to get authentication with AD and to do this I've already made this code. Can anyone provide me if it's correct or not to do this or if I have a better solution.
...
4
votes
1
answer
1k
views
Count bits in VBScript
I'm trying to write a function that returns the number of bits set in a 32-bit integer in VBScript, it's just for practising the language. The function I've written so far looks okay, but I'm ...
4
votes
2
answers
2k
views
VBA copy paste loop
I have 2 Excel files: the first is the source file "Practice_New.xlsx" and the second is a mapping file "A_File.xlsx". A_File is a mapping file which contains cell reference of the source file ("...
5
votes
0
answers
123
views
Counting instances of a string in a binary / unicode file using regex [closed]
(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 ...
6
votes
1
answer
4k
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
1
answer
133
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 ...