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

byRyanIrish
27
Hi,

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

How to calculate Duration from text and number cell value

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

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

byvikram bharadwaj
2
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

byJohn Sheehy
20
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

byEuro5
11
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?

bykbay808
126
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

byVinay
50
Hi All,

Need small help in developing the Vb script.

We have 2 files as below

File1:

ColumnA   ColumnB

A  …
Troubleshooting Solution

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

bybfuchs
14
Hi Experts,

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

VBS script amend to work on sub folders

byJames Murrell
6
I had this question after viewing .BAT file to Open Excel Files in a folder, Save and Close.
i and
…
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

byJoe User
45
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?

byMillard Melnyk
15
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

byEvert Jor
6
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?

byf19l
31
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

byJohn-DSC
8
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.

byCulwatrnca11
9
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

byE=mc2
10
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?

byf19l
19
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

bysparker1970
17
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

byMurry Camper
16
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.

byICT Department
19
Hi,

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

Collaborate

Monitor your Site

Explore solutions and more