Suppose you have an excel file with thousands of rows and you want to look for a particular value. The simple approach of using a for loop to iterate through the rows […]
In Automation, Excel files play an indispensable part. Out of the many uses they have, creating reports is one of them. Now when you create a report with the help of an […]
The following code can be used to find out the office version :- Dim regEntryOffice regEntryOffice =”HKEY_CLASSES_ROOT\Excel.Application\CurVer\” If WshShell.RegRead (regEntryOffice)=”Excel.Application.12″ Then Environment.Value(“OfficeVersion”)=”2007″ Elseif WshShell.RegRead (regEntryOffice)=”Excel.Application.14″ Then Environment.Value(“OfficeVersion”)=”2010″ Elseif WshShell.RegRead (regEntryOffice)=”Excel.Application.15″ Then Environment.Value(“OfficeVersion”)=”2013″ […]
Automating Microsoft Excel – Part 1 – How to Create an Excel Object, Enter and Retrieve Values from it.
This is Part 1 of the Series where I’ll be explaining how to Automate MSExcel using QTP. First of all, one needs to understand the Excel Object Model in order to use […]
Automating any Microsoft Office Application can be a big challenge in itself. Purely because any Office Application(Excel/Word/PowerPoint/Outlook) can’t be directly automated with QTP’s object identification mechanism. During the course of my fights […]