How to read excel using ADODB connection
Excel workbooks are the most common and an excellent way of storing data. Did you know you can connect to the excel workbook as a…
How to connect database using VBScript- Complete tutorial for SQL, Oracle, MySQL, Excel, Sybase, MS Access
VBScript provides one of the best ways to connect to any kind of database. That is through the ADODB connection. Lets see how to connect…
How to connect to a network using VBScript
Using VBScript, we can easily work with automating network connections such as: Connect to wifi , Disable a firewall etc. VBScript comes with inbuilt capability…
How to upload a file through FTP using VBScript
File upload is a crucial part of test automation. There may be several use cases where you need to upload a file through ftp using…
Best UFT Synchronization method – How to handle dynamic wait in UFT/QTP using readyState value 4
In any test automation framework, browser handling is the most important part during automation scripting. UFT Synchronization – Let’s see how to handle synchronization in…
How to launch chrome incognito using UFT
Using UFT we can launch Chrome incognito with the help of a small program. First, we will create an object of shell and then we…
Get menu and submenu names in the Windows application using UFT
UFT works very well with Windows as well as web applications. To get menu and submenu names in the Windows application, we can create a…
String reverse in VBScript without using inbuilt function
String reverse in VBScript is a very common task. If you need to reverse a string in VBScript without using inbuilt reverse functions, we can…
Verify a string is present in an array using VBScript
In order to verify a string is present in an array, we will utilize the dictionary object provided by VBScript. First, we will create an…
Count Alphabetical characters using VBScript
In order to count Alphabetical characters using VBScript in a string, first we need to get the characters from the given string, one char at…
Verification of Palindrome using VBScript
A palindrome is a word, sentence, verse, or even number that reads the same backward or forward. For example- ATATA, BOB, 12321 In order to verify…
How to write data into Excel using VBscript
In order to write data into Excel using VBScript, we can leverage Excel.application object. This object provides multiple methods which help us to create, open,…
VBScript Error Handling – On Error Resume Next, On Error Goto 0
VBScript Error handling in UFT automation scripts is very important like in any other language. We have some very common VBScript examples to demonstrate it….
How to get column index in a webtable using UFT
Suppose that there is a webtable on the page and you have a column name. Now if you want to get the column index in…
How to get most repeated value from excel using VBScript
In order to get most repeated value from excel using VBScript, we have a ready-to-use function created in VBScript. All you need to do is…
How to associate function library at runtime in UFT- Complete code
The function library is the backbone of any test automation framework. You can associate function library at runtime using AOM. It is designed to handle…
How to select all text using UFT- CTRL+A and CTRL+C method
There may be some instances where you need to copy and paste or select all text using UFT. This can be achieved in many ways…
How to create a text file using VBScript – CreateTextFile
If you have to create a text file using VBScript, it provides a very efficient tool FileSystemObject. Further, there are many methods provided by FileSystemObject…
How to create a folder using VBScript – FileSystemObject
FileSystemObject can be used to create a folder using VBScript. FileSystemObject also known as fso is one of the most efficient tools provided by VBScript. We…
How to check all checkboxes in UFT – ChildObjects in UFT
If you want to check all checkboxes in UFT on a webpage, there are many ways to do that. One of the most used approaches…