Showing posts with label VBScript. Show all posts
Showing posts with label VBScript. Show all posts

VBScript code to convert Excel data to HTML format

›
This article explains the code to convert content of an excel file into html code. This can be useful for better representation of excel...
2 comments:

Code to get title of all open browsers in QTP/UFT

›
We can get titles of all the open browser open using descriptive programming in QTP as explained in the code below: Function GettitleA...
1 comment:

Useful Batch file commands

›
Batch files help user to execute series of commands in the batch file. We can execute large number of commands in one go using bat file. ...

Renaming all/specific subfolders in a folder using vbscript FSO

›
In this post, how to rename all the subfolders in a folder using vbscript is explained Renaming all sub folders in a folder removing spa...

UFT test information and failure reason from result.xml file

›
While running the UFT test in batch,we need to capture executed test information including testname, test execution status and reason for ...

Manipulation XML using XPath for VBScript/UFT

›
This article explains how to extract information from an xml file based on the element xpath using Microsoft.XMLDOM and VBSript . You can ...

VBSript Code: copying text from HTML webPage to Local

›
In this article, Code to copy html content from a web html page to local machine is explained. You  can try the code, saving it as vbs f...

Sorting excel data multiple times based on column Name using VBScript

›
''Input Information - Workbook file Name with path ''WorkSheet Name '' Provide the sort criteria based on which...

VBScript Code to close the IE browsers and Internet Explorer not responding window

›
VBScript Code to close the IE browsers and Internet Explorer not responding window Set WShell = CreateObject( "WScript.Shell...

VBA Code- Extracting Database data into excel sheet using macro

›
Code to read the data from database and writing data in excel file using VB Macro and VBA. '''' Naming the sub as au...
1 comment:

VBA Code: How to auto trigger operation on opening or closing an excel file

›
Problem : We need to perform or auto-trigger some operation while opening or closing an excel file. There may be operations required by ex...
2 comments:

How to compare arrays after sort data in Array using VBScript in QTP

›
In this article, we will discuss how to work with arrays explaining the below concepts: How to sort data in the array. How to compare ...

What is the difference between ByRef and ByVal? –QTP Interview question

›
B yRef and ByVal are two ways to pass arguments to a function or subroutine in VBScript. Understanding the difference between two is simpl...

VBScript Code - Function to convert CSV file into excel and viceversa in QTP using VBScript

›
We at times are required to convert excel files into csv to read as flat files and sometime require to convert a csv file into excel file...
1 comment:

How to create and work with Class using VBScript Code in QTP

›
Using Class in VBScript, we are able to create an instance of object and use properties and methods of the object.  Points to remember...

How to use err object to continue test execution in VBSript and QTP

›
''Err object holds the information for last runtime error that occurred in the test execution '' In the piece of cod...

How to create array from string separated by delimiter using vbscript split function

›
Suppose we have a string with value as :  stringA = "nitin>joshi>qa>qtp>automation" '' We can create an ...