Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tandem
 
Posts: n/a
Default 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   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
tandem
 
Posts: n/a
Default

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   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't open workbook (in Excel 2000) gcotterl Excel Discussion (Misc queries) 2 January 23rd 05 01:42 AM
How to open a workbook with a specific worksheet displayed by defa ThaiNB New Users to Excel 2 January 21st 05 07:11 AM
Can Excel open each workbook in a seperate window JVC Dude Setting up and Configuration of Excel 2 January 15th 05 02:01 AM
Does file need to be open for INDIRECT to another workbook to work briancrosier Excel Discussion (Misc queries) 2 December 15th 04 05:25 PM
How do I open a shared xls workbook on a PC and Mac at the same ti Debs Excel Discussion (Misc queries) 2 December 8th 04 06:25 AM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"