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

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  …
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

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

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

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 …
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, …
Article

VBScript WMI Tutorial: Retrieve Free Space On C Drive From Multiple Computers

byRobSampson
14
IntroductionDuring my participation as a VBScript contributor at Experts Exchange, one of…
Troubleshooting Solution

Modify .csv file via script

byelwayisgod
90
Not sure possible or not but worth a try.  I have a file 'source.csv'.  It's a ^ delimited file.  I …
Troubleshooting Solution

2014 SQL Server Backup

byK Feening
19
Trying to create backup on Desktop to local c: from remote server Mapped p:

Code -

server = …
Troubleshooting Solution

VBScript to do a POST to a URL, get the response and parse to response so each item can be written to screen

byGeneBe
13
I get a json reponse from an api call with the URL below. IP0054870896 is the IdKey

This URL …
Troubleshooting Solution

Batch script to HTA script

byGabriel Clifton
82
I have a batch script that I use that works well, but I am wanting to convert it into a HTA script …
Troubleshooting Solution

API CALL IN VBSCRIPT

byGeneBe
11
this api call "http://localhost:44382/api/IPauthinfo/IP0054870896" 
I have a c# program that give …
Troubleshooting Solution

Windows batch: transpose VBScript to Windows batch (copy process)

byLuis Diaz
22
Hello experts,

The following VBScript allows me to create a datestamp folder and copy files & …
Troubleshooting Solution

How to better understand the VBS Editor

byBob
7
I am 'self-taught' regarding developing somewhat simple Access databases..Some for Non-Profits and …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more