Macros are limited in their ability. Often linear in nature and written to perform a single task. RPA is a much more sophisticated and comprehensive automation and transformational technology. It is dynamic in nature and can perform several tasks and full-blown processes.
There are a few tips to apply to test the suitability of a process for RPA. For example, RPA favors high volume transactional processes that do not require human judgment and have simple business rules. This does not mean that every process that falls under this category is a fit, but it is a good start. We recommend engaging in a full assessment of a set of RPA candidates. Only through due diligence can one determine whether or not a process is fit for RPA.
Here is a simple graphic that sheds some light on exactly this question
There are quite a few vendors now in the RPA space. However, the last several years have had the same three names interchangeably at the top. Blue Prism, UiPath and Automation Anywhere.
A COE is a corporate group, team or group of professionals that provides leadership to other employees and the organization a whole in a specific discipline. In this case the RPA discipline is one such area that a center of excellence is frequently used tackle this new technology and ultimately drive adoption.