Explore VBScript on Experts Exchange

Expert Solutions for Your Tech Problems

VBScriptVB Script

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with som...

Read more
  • 38K Content
  • 8.4K Contributors

Troubleshooting Solution

VB code help to increment an alphanumeric serial number


I have small snippets of VB code embedded in our labeling forms that query our db for the last …
Decision Making

How to calculate Duration from text and number cell value

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.

Hello Team,  I created a VB Script. This script opens …

Hello Team,

I created a VB Script. This script opens excel sheets and refresh data connections.  …
Troubleshooting Solution

Access 2016 DateAdd with VB Update SQL Statement

Having another issue with the following line:
All it needs to do is set the field Archived to Yes, if …
Troubleshooting Solution

vba script error

I have a script calling a macro in excel .xlsm
I have screenshots of all the process, hoping that …
Troubleshooting Solution

How to create a vba code to extract a string of data from the “View Source” code from an active IE window into a cell in excel?

I need to create a vba code that will complete the following tasks:
1.      Simulate right clicking …
Research Solution

Need help in developing Vb script

Hi All,

Need small help in developing the Vb script.

We have 2 files as below


ColumnA   ColumnB

A  …
Troubleshooting Solution

Cannot export record from SQL database to Access, Max size reached...

Hi Experts,

I've a SQL BE database (Caspio FE) that contains records I need to export to Access …
Troubleshooting Solution
Troubleshooting Solution

How to edit 2 cell fields in multiple excel files in a folder/subfolders automatically using VBA based on starting name of file

How to edit 2 cell fields in multiple excel files in a folder/subfolders automatically using VBA …
Troubleshooting Solution

Puzzled, "AS NEW Scripting.Dictionary" -- Why does one work but not the other?

If I early bind a Scripting.Dictionary and set it to Nothing , it doesn't work.

bypasses the MsgBox 
Troubleshooting Solution

How to split a line in ASP

Hi! I'm trying to find a script to split a line after approx. 55 characters ie split into a new …
Troubleshooting Solution

What is the excel visual basic code to open up a brand new excel application via the Start window?

I have a spreadsheet that I open up each morning. It contains a macro such that when I run it a …
Troubleshooting Solution

What is a "Best Practice" for connecting to SQL server from a VBScript so no password displays in the VBScript

I have investigated many options and I want to know of any options I missed and what is the "Best …
Troubleshooting Solution

script to show hours, minutes and seconds. Used to measure how long a certain batch file takes to run.

Modify the below to show hours, minutes and seconds for run time.Currently shows seconds only and I …
Troubleshooting Solution

Emulate this Powershell script into a batch file instead

I would like to emulate this Powershell script, as shown below - to convert it as it were to a .bat …
Troubleshooting Solution

What is the VB code so that  I can declare a variable when I open a spreadsheet that can be used in any module and sub routine?

Hello, I have multiple spreadsheets that I use each day and I would like to know how I declare a …
Troubleshooting Solution

Trying to Get a VB Script to split a text file into multiple

I have a text file I receive from a client where they send us a single file with multiple record …
Troubleshooting Solution

Need script to monitor file size of an XML file

I need a script to monitor an XML file and execute blat to alert me if the file size of the file …
Troubleshooting Solution

Autoforward email and change from to the first emailaddress found in the body.


We receive email from one address (let's say ticketsystemA@domain.com) with support tickets, …

Do more with Experts Exchange.

Get Answers

Take a Class


Monitor your Site

Explore solutions and more