Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help! Save xla to xls (2000)

    Please help! A colleague of mine save by mistake his xls file to an addin, as xla, and now when he opens the file, it looks empty, even though in Windows Explorer we can see that the data is there, due to the file size.
    Saving it as an xls in Excel or renaming the extension in Windows Explorer wouldn't work!

    Thanks a lot in advance!
    K.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help! Save xla to xls (2000)

    Follow these steps:
    - Open the xla
    - open the VBE (alt-F11)
    - Find the entry for the xla in the project eplorer (View, project exporer) and expand it
    - find the Microsoft Excel Objects item
    - select the Thisworkbook Object
    - now open the properties window (View, properties)
    - find the entry that reads IsAddin and change it to False
    Attached Images Attached Images
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help! Save xla to xls (2000)

    Thanks a lot, you saved the day! [img]/forums/images/smilies/smile.gif[/img]
    Poor guy was working for a week now on this database and he was already pulling his hair out!

    Best regards,
    K.

Posting Permissions

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