Are there any differences between RPA, running scripts, or using macros?

There are similarities and differences. RPA software is several orders of magnitude more powerful than any script or macro. Part of that strength comes from the ability to link multiple robots and use the collective knowledge of the entire network. RPA systems place a high value on the governance of the processes, something scripts and macros cannot do.