Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    .xla back to .xls (Excel xp)

    We have an excel add-in that someone developed that has left the company. It is password protected and no one has the password. Is there a way i can make the .xla back into an .xls? Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: .xla back to .xls (Excel xp)

    If you do a Google search for "Excel password cracker" (without the quotes), you get oodles of hits.

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

    Re: .xla back to .xls (Excel xp)

    As far as I know, there is no way to convert a .xla file back to .xls. I believe that all of the source for the macros has been deleted from the file. I also don't think that the .xla file is really password protected, there just isn't anything in it that can be viewed, so XL marks it unviewable. You will have to have to original .xls file.
    Legare Coleman

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: .xla back to .xls (Excel xp)

    Legare,

    what you say about the source being deleted in the case of an AddIn, this may have been true in versiuons prior to XL97, but since you simply just need to use Workbooks("Addin.xla").IsAddin = False. However if the VBAProject is password protected, then the password is needed to access the code.

    Andrew

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

    Re: .xla back to .xls (Excel xp)

    OK, thanks for straightening that out.
    Legare Coleman

Posting Permissions

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