Excel Application Scope COM Exception

Help
,
1

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.

2

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

3

can you please detail it

4

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.