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.