Identify the excel file that may need a password

[Gowrisankar]

Dear members of the forum,

I need to open excel files that may or may not need a password and finally move the files that needs password to manual queue.

Is there a fastest way to do this?

 

PS: I have a huge respect for the rules of this forum. I am not asking assistance to override any security measure. I just need to segregate the files that needs passwords.

[JLogan3o13]

Last I knew there was no way to know if a workbook was password protected without opening it (someone may prove me wrong). About the best you could do was loop through your list of files and try to open them (look at _Excel_BookOpen) by specifying the password parameter (a simple "abc" will suffice). If the workbook has no password on it, it will open with a code 0; if it does have a password it will throw an @error of 3 and @extended of -2147352567. You can then move the file.

Pseudo:

#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @DesktopDir & "\test.xlsx", True, True, "abc", "abc")
    If @error Then
        if @extended = "-2147352567" Then
            ;Move file
        Else
            ;Handle other @error such as missing file
        EndIf
    Else
        ;File not password protected, do whatever
    EndIf

_Excel_BookClose($oWorkbook)
_Excel_Close($oExcel)

 

[Gowrisankar]

Thank you so much @JLogan3o13

[water]

@JLogan3o13,

great solution
I've added it to the Excel section in the wiki.

[Earthshine]

yeah, it's really the only way to do it, literally. Same way in C#, etc..