Blog Archives

Automating Microsoft Excel Part 4 – How to Automate MS Office Ribbon

If you are banging your head(which I quite frequently do) with GUI Automation of a Microsoft Office application, then this post is a must for you. QTP’s object Spy does not identify any of the Ribbon controls in any Office

Tagged with: , , , , , , , , ,
Posted in Awesum Stuff

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,300 hits
Categories

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

Join 796 other followers