Blog Archives

Automating Microsoft Excel Part 3 – Using Find command through code

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 and look for the value is ineffective in

Tagged with: , , , , , , , , ,
Posted in MSOffice Automation

Automating Microsoft Excel Part 2 – Formatting an Excel File

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 automation script, you would also like to format

Tagged with: , , , , , , , , , , ,
Posted in MSOffice Automation

How to Find MS Office version with QTP/VBS ?

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″ End If Happy Automating ! Harshit Kohli

Tagged with: , , , , , , , , , , ,
Posted in MSOffice Automation

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 the numerous functions provided by Excel API. So

Tagged with: , , ,
Posted in MSOffice Automation

How to Automate any MSOffice Application

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 with QTP, there was one battle that required

Tagged with: , , , , ,
Posted in MSOffice Automation
Blog Stats
  • 168,300 hits
Categories

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 796 other followers