Click here to Skip to main content
11,496,146 members (343 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: C

Can anyone of you know at which offset in hex editor password is found in encrypted form if excel file is password protected.


Is there any way to get the encrypted password of excel file through code..

Thanks and Regards
Nidhi Smile | :)
Posted 10-Mar-11 19:36pm
hi tanu,

i think this link can help You[^]

check it out.

Bbye tc
tanu misra at 11-Mar-11 2:25am
thanks sam_ckp

I tried this link...can you suggest me something else......... :)
Tell me abt ur version of MSExcel.
R u forgot ur password ??

try below link[^]

i Tried in 2003 XLS file, using Excel 2007

1. Backup the xls file
2. Using a HEX editor, locate the DPB=... part
3. Change the DPB=... string to DPx=...
4. Open the xls file in Excel
5. Open the VBA editor (ALT+F11)
6. the magic: Excel discovers an invalid key (DPx) and asks whether you want to continue loading the project (basically ignoring the protection)
7. You will be able to overwrite the password, so change it.
8. Save the xls file
9. Close and reopen the document and work.
tanu misra at 11-Mar-11 3:12am
I'm using excel 2003.
I'm studying excel file format,and wanted to know the offset where encrypted password is kept..
hi dear

u can find all the specification of msexcel in below book


try to download above ebook, if u wanna from me then mail me on
tanu misra at 14-Mar-11 0:06am
thanks for the link.. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600

Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 11 Mar 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100