VBA : how to read password protected file

  • Dear All,

    Is it any way to read a excel file which is protected with password. i do not want to modify. i want to know what is in the file .

    Help will be appriciated.


  • Dave has a policy whereby no-one on this forum should give out information to break Excel passwords / bypass security...We have no way of knowing whether the person who set the password intended you to read the document do we? There are password breakers available on the net & people who offer the services... but we do not I am afraid.

    see the forum rules


    7: The offering of help to bypass Macro Security is not allowed. Download this Workbook for a friendly way to encourage enabling of macros.