Excel Application Scope COM Exception

excel
activities

#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.