Facts of Automation Testing

Excel Operation in VBScript In this post we will see how to interact with excel application through vb script, QTP / UFT, Microsoft excel follows hierarchy mentioned as below Excel -> Workbook -> Worksheet -> cells. Using vb script we can perform below operation on excel object 1.        Create New Excel sheet 2.        Open Existing File 3.        Add new sheet under same workbook 4.        Copy Data from another sheet 5.        Format excel tables and cells 6.        Read data from excel 7.        Write data in excel 8.        Remove sheet from workbook 9.        Hide/Unhide sheet in workbook 10.    Protect/Unprotect sheet Also you see above operations video tutorial ...

In this post we will see File system object usage in vb scripting with below mentioned operations   File system object introduction   Create  text file   Access as existing drive, folder and file   Verify existence of file   Verify existence  of folder   Create new folder   Write text in file   Read text from file   Copy file paste file   Move  file   Delete file   Difference  between readAll and readline method        Fetch drive, folder and file information File system object introduction -:  File system object is very useful while perform folder, file and drive operations likely add, move, change, create, delete and fetch object information. Scripting allow you to perform above operations on windows environment. FSO object provides access to below mentioned collections object. Drive -: this object provides object and methods to gathe...