Excel Application Scope COM Exception

Unable to use excel application scope GetSheets for protected sheets.
It throws COM exception
Is there alternate way to get sheet names.
Read Range will work only if i specify the sheet name.

you can try with an excel macro that you execute using our activity

can you please detail it

you create a macro inside excel that unlocks the password for those sheets you are trying to work with, you execute it using our activity, save and then do the read/writes activitties on the file.