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.


    Thanks

  • 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

    Quote

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


    Sorry,


    Will