We are looking to automate our application.
It is an excel based application.
When we login into our application, we have the abitlity to open some excel documents from with in the application. These documents are not stored in local machine in some path. They are fetched from the DB.
We place some data into the excel document which we call project and then calculate it and see if the out put cells in the project are getting populated with correct values.

I want to know if Ranorex has the abitlity to identify the excel sheets with cell names and does it identify the named regions in excel?

Also within excel, we have some custom controls created by us. Clicking on which would open new windows.Can you please tell me if Ranorex would identify these controls.

These are our major requirements.
If these are supported, we would look at buying licenses.

As for your custom controls, what I suggest is download and install the Ranorex trial version. Use RanorexSpy to spy on your controls and see what information is available to you. Assuming your dev team follows standard operating procedure you should have no (or very few) immediate issues interacting with your custom controls.

If this or any response has helped you, please reply to the thread stating that it worked so other people with a similar issue will know how you fixed your issue!