How to create a low maintenance keyword driven framework

If you're changing your Alias every time you update the mapping, then you're using Aliases wrong.

Let's take for example the following.

Say I have an object on a web page mapped like so.

NameMapping.Sys.browser.myPage.panel.table.cell.panel.panel.buttonOK

Now, I'm just using the naming because this is sometimes how TestComplete auto-maps things. Typically, I'd recommend more detailed and direct names but you get the idea.

Now, auto-mapping would then create the Alias like so.

Aliases.browser.myPage.panel.table.cell.panel.panel.buttonOK

However, this is unnecessary.  As a rule of thumb here in our environment, we don't create an Alias reference for an object unless it is directly needed or necessary within the test case.  So, let's say ONLY the first panel above is really relevant.  In TestComplete, you can alter the Alias to read like so

Aliases.browser.myPage.panel.buttonOK

and preserve the original NameMapping.  The test cases will then reference the Alias and everything is peachy.

Let's say, then, your developers change the page so that one of those extra panels is removed so it's no longer necessary.  You can edit the NameMapping then to click and drag things around and then delete objects within the Mapped Objects part of NameMapping so you get the following.

NameMapping.Sys.browser.myPage.panel.table.cell.panel.buttonOK

By editing and manipulating the NameMapping ONLY, just by dragging things around, the object identification continues to work.  The Alias NEVER needs to change.  You can keep the Alias to be the same designation as much as you want.  You can edit, rename, update, change, etc., the mapping of an object in all sorts of ways and, so long as it continues to be referenced by the same Alias, your Alias never changes.

So, in your situation, your Excel can continue to use the same Alias name for as long as it is still relevant.  You never need to update the Excel sheet.  Just update the Mapped Objects section of your NameMapping when the application changes.

THIS is exactly what Aliases were created for... to make a low maintenance framework so you can change the underlying object identification factors without having to change how they are referenced in your actual test cases.