Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Catia macros password

Status
Not open for further replies.

Gilgamesh99

Automotive
Jun 11, 2013
45
MX
Hi:

Recently I developed a macro and I protected it with a password. Now I need to see the code and it seems I forgot the password!!! Is there any way to retrieve it?

Thanks in advance.

 
Replies continue below

Recommended for you

It works with CATIA macros as well!!!:


There is another (somewhat easier) solution, without the size problems. I used this approach today (on a 2003 XLS file, using Excel 2007) and was successful.
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 to something you can remember
8. Save the xls file*
9. Close and reopen the document and work your VBA magic!

*NOTE: Be sure that you have changed the password to a new value, otherwise the next time you open the spreadsheet Excel will report errors (Unexpected Error), then when you access the list of VBA modules you will now see the names of the source modules but receive another error when trying to open forms/code/etc. To remedy this, go back to the VBA Project Properties and set the password to a new value. Save and re-open the Excel document and you should be good to go!

taken from:

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Top