Is RPA like screen scraping or macros?

It is similar, but much more advanced. The idea of RPA came from macros, but the major difference is that an RPA solution is a universal application orchestrators. Any application that can be used by a person can be used by a modern robot, whether mainframe, legacy, bespoke application, web service enabled or even a closed 3rd party API hosted service.