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

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
Blog Stats
  • 168,304 hits
Categories

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

Join 796 other followers