After a little digging I realized that the password protected file is not attached to the Excel connector when opened this way. The workbook opens but there is no way to switch it so it is under the Excel connector's control. Therefore, to run a macro you will need to extract a proxy from the workbook's Application property. This is available from Explore Component Properties in the Object Explorer. This proxy will have a Run method which allows you to run a macro from the workbook. It takes a macro name and up to 30 arguments. Send a System.Reflection.Type.Missing to any parameter you do not need.