Excel and Powershell Question

So I am trying to help write a script that goes through different excel workbooks and runs a macro in order to normalize data. But I am running into a set of errors that I don't understand. I thought all of the expressions were defined and don't quite understand what is happening.