Excel.Application.Run and VBA.Interaction.CallByName both seem to do similar things; namely calling a method using a string name. As I understand it, this functionality is enabled because VBA is an automation language and uses IDispatch for a lot of its objects and internal working.
What has this got to do with Excel then (or indeed PowerPoint.Application.Run)? Why is calling members of standard modules vs class modules so different?