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.