How do i get the active ribbon tab name?

Question

I have been searching the net for 2 days but found nearly nothing about this issue:

• How do I work with the Ribbon (Menu) in Excel?
• How do I get the active ribbon tab name?
• How do I select the Home or Data tab?

Answer 1

The tab-scaling feature was introduced with Office 2010. So, you need to use Accessibility API to get the required information (do whatever you need).