Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jul 2002
    Location
    Glasgow, United Kingdom
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spontaneous Excel Password

    I created file in Excel 2000. It includes VBA Autoopen & close simply to create/delete toolbars plus some innocuous code for the buttons
    Closed it - opened the next day & it demanded a password!
    (I had previously tested the VBA & it worked fine)
    I can find only 1 other person who has had a similar thing happen - but the info they had was basic stuff & they just deleted the file - so no help there
    I've bought a password recovery utility "Office Key" from "Passware" but it's struggling to open it
    Has anyone come across this before or know of a solution?
    Any help appreciated
    Michael

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Spontaneous Excel Password

    There is a shareware program called Excel Recovery. It is here.

    I think you have a corrupted file. Before recovering it copy it in case I am wrong!
    David Grugeon
    Brisbane Australia

  3. #3
    Lounger
    Join Date
    Jul 2002
    Location
    Glasgow, United Kingdom
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spontaneous Excel Password

    Thanks for suggestion David

    I've tried it - it opened but presented me with an empty file!
    The main data I'm after is the code in the vba modules

    If I "send the file" to wordpad, all characters appear to be encrypted except the "commented out" script in the code which can be read easily - that's what made me think the file itself wasn't corrupt

    Anyway - thanks for trying & I now have access to a utility I hadn't heard of before. Something good nearly always comes out of a disaster!!
    Michael

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spontaneous Excel Password

    Have you checked your system for a virus. I seem to remember a virus that would cause this symptom. If there is nor virus, then the most likely thing is a corrupted file.
    Legare Coleman

  5. #5
    New Lounger
    Join Date
    Mar 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spontaneous Excel Password

    The only other time that I encountered unexpected passwords was if a user was not correctly logged onto our intranet and the function had something to do with a program or file on our intranet (i.e. internet explorer or printing functions).

  6. #6
    Lounger
    Join Date
    Jul 2002
    Location
    Glasgow, United Kingdom
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spontaneous Excel Password

    Thanks for the all the replies
    Everything seems to point to a corrupted file!
    I've now redone the file but it just re-inforces the emphasis on making backups of important things - it would have saved me hoooours!
    Again thanks for all replies
    Michael Sayers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •