Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can no open workbook
I have a big problem with my xls workbook file: I forgot password I set up
and can no open file anymore. Its a file-level protection, so now I just prompted enter password when I try open file.. There are some macro that can solve problem and just remove protection, but I can no find the necessary code. I tried some code from Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) http://www.mcgimpsey.com/excel/removepwords.html but it intended for removing password from open workbook only.(not fully clear what 's the necessary to remove password from the workbook already open) thanks |
#2
|
|||
|
|||
tandem,
Here is a post of resources by Norman Harker: http://www.google.com/groups?threadm...GP12.phx .gbl -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "tandem" wrote in message ... I have a big problem with my xls workbook file: I forgot password I set up and can no open file anymore. Its a file-level protection, so now I just prompted enter password when I try open file.. There are some macro that can solve problem and just remove protection, but I can no find the necessary code. I tried some code from Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) http://www.mcgimpsey.com/excel/removepwords.html but it intended for removing password from open workbook only.(not fully clear what 's the necessary to remove password from the workbook already open) thanks |
#3
|
|||
|
|||
Paul,
thank you for links. However, I still not found there some excel macro based solution, not the utility. thanks, tandem "Paul B" wrote in message ... tandem, Here is a post of resources by Norman Harker: http://www.google.com/groups?threadm...GP12.phx .gbl -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "tandem" wrote in message ... I have a big problem with my xls workbook file: I forgot password I set up and can no open file anymore. Its a file-level protection, so now I just prompted enter password when I try open file.. There are some macro that can solve problem and just remove protection, but I can no find the necessary code. I tried some code from Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) http://www.mcgimpsey.com/excel/removepwords.html but it intended for removing password from open workbook only.(not fully clear what 's the necessary to remove password from the workbook already open) thanks |
#4
|
|||
|
|||
I don't think this can be done with an excel macro
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "tandem" wrote in message ... Paul, thank you for links. However, I still not found there some excel macro based solution, not the utility. thanks, tandem "Paul B" wrote in message ... tandem, Here is a post of resources by Norman Harker: http://www.google.com/groups?threadm...GP12.phx .gbl -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "tandem" wrote in message ... I have a big problem with my xls workbook file: I forgot password I set up and can no open file anymore. Its a file-level protection, so now I just prompted enter password when I try open file.. There are some macro that can solve problem and just remove protection, but I can no find the necessary code. I tried some code from Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) http://www.mcgimpsey.com/excel/removepwords.html but it intended for removing password from open workbook only.(not fully clear what 's the necessary to remove password from the workbook already open) thanks |
#5
|
|||
|
|||
tandem
There are some macro that can solve problem and just remove protection, but I can no find the necessary code. You cannot crack a File Open password using VBA See J.E. McGimpsey's site for cracking File Open Passwords. You need a third-party utility at least. http://www.mcgimpsey.com/excel/fileandvbapwords.html Gord Dibben Excel MVP On Tue, 30 Nov 2004 18:55:45 +0200, "tandem" wrote: Paul, thank you for links. However, I still not found there some excel macro based solution, not the utility. thanks, tandem "Paul B" wrote in message ... tandem, Here is a post of resources by Norman Harker: http://www.google.com/groups?threadm...GP12.phx .gbl -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "tandem" wrote in message ... I have a big problem with my xls workbook file: I forgot password I set up and can no open file anymore. Its a file-level protection, so now I just prompted enter password when I try open file.. There are some macro that can solve problem and just remove protection, but I can no find the necessary code. I tried some code from Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) http://www.mcgimpsey.com/excel/removepwords.html but it intended for removing password from open workbook only.(not fully clear what 's the necessary to remove password from the workbook already open) thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't open workbook (in Excel 2000) | Excel Discussion (Misc queries) | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
Can Excel open each workbook in a seperate window | Setting up and Configuration of Excel | |||
Does file need to be open for INDIRECT to another workbook to work | Excel Discussion (Misc queries) | |||
How do I open a shared xls workbook on a PC and Mac at the same ti | Excel Discussion (Misc queries) |