We are trying to automate some custom Excel Add-Ins (e.g. Smartview, Vision) using SendKeys to navigate the tabs using Excel keytips. I have seen some threads around automating Smart View but as we are doing this with several other Add-Ins we would like to explore this solution as it is re-usable. However these keytips keep changing and are different from machine to machine. Is there a way to dynamically get the keytips values using a code stage? Have seen snippets of code involving the 'GetKeyTip' method but unsure what the specific syntax would be.
Any thoughts would be much appreciated.
Cheers!
Any thoughts would be much appreciated.
Cheers!