No announcement yet.

Open worksheets in an xla for editing

  • Filter
  • Time
  • Show
Clear All
new posts

  • Open worksheets in an xla for editing

    Got another problem.

    How do I convert an xla file back to an xls file to edit worksheets or is it possible to open the worksheets in an xla file for editing?


  • #2
    Re: Open worksheets in an xla for editing

    Have you tried copying the .xla file - saving it somewhere and then renaming it - ie changing the extension to .xls?

    General advice on .xlas is to save an .xls duplicate, prior to converting the original to an .xla


    • #3
      Re: Open worksheets in an xla for editing


      I just did a quick test and this opened the worksheet in xl97:

      Open the xla file
      Open the VBEditor
      Select View>Properties Window
      Select View>Project Explorer
      In Project Explorer, highlight ThisWorkbook
      In Properties - ThisWorkbook change the IsAddin property = False

      I could then edit the worksheet, but I didn't save or test any changes, so you're on your own after that.

      P.S. Just wondering... Since changing the Addin property to True hides the worksheets in a xls file, could this be a solution for those wishing to only display a userform? i.e...

      Displaying userform
      If Not ThisWorkbook.IsAddin = True Then ThisWorkbook.IsAddin = True
      Returning to workbook
      Unload UserForm1
      If Not ThisWorkbook.IsAddin = False Then ThisWorkbook.IsAddin = False
      Last edited by dangelor; November 27th, 2004, 23:44. Reason: added post script


      • #4
        Re: Open worksheets in an xla for editing

        An xla wa once an xls as have been pointed out above, some guys save original and convert to xla, some dont, this is my prefered menthod, however if you change the isaddin properties in the VBE Properties then the xla will revert back to xls format ie sheets can be viewed, but this is still not an xls it is only a fully open xla, save will save changes if you save inside the vbe, do not save in excel itself, and do not forget to complie the project / xla before converting back to closed xla in the VBE properties.

        This advice assumes you have access and the xla is not password protected.



        • #5

          Re: Open worksheets in an xla for editing

          Thanks for the help guys,
          Copying and renaming dosen't work in Excel 2000. I changed it from an addin in the properties window and it worked fine

          Thanks for the help!!