Excel has two different workbook protections that require a password. At my company most files are opened as read-only unless you supply a password.
Using the Excel application scope activity and providing it the password doesn’t seem to work. It seems like no data is passed to excel, so nothing will happen until you manually enter the password.
I’ve also tried using the “type into” activity, as well as using the “type into” activity in parallel, but nothing works and it keeps getting stuck trying to open. Is there a way to supply excel the password so that the file can be opened and editable?