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