Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Open worksheets in an xla for editing

  1. #1
    Join Date
    8th September 2003
    Posts
    244

    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?

    thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th May 2004
    Location
    London
    Posts
    447

    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    26th January 2003
    Location
    Indiana, USA
    Posts
    784

    Re: Open worksheets in an xla for editing

    JJacob

    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
    VB:
    If Not ThisWorkbook.IsAddin = True Then ThisWorkbook.IsAddin = True 
    UserForm1.Show 
    
    
    Returning to workbook
    VB:
    Unload UserForm1 
    If Not ThisWorkbook.IsAddin = False Then ThisWorkbook.IsAddin = False 
    
    
    Last edited by dangelor; November 27th, 2004 at 22:44. Reason: added post script

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,684

    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.

    Jack

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    8th September 2003
    Posts
    244

    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!!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Automatically Open Worksheets At A1
    By catshoes in forum EXCEL HELP
    Replies: 6
    Last Post: August 2nd, 2008, 21:21
  2. Open worksheets
    By rikapple in forum EXCEL HELP
    Replies: 1
    Last Post: January 16th, 2006, 22:21
  3. All Worksheets But One Hidden On Open
    By tim7180 in forum EXCEL HELP
    Replies: 4
    Last Post: March 23rd, 2005, 23:20
  4. Open multiple worksheets
    By mpoumpou in forum EXCEL HELP
    Replies: 1
    Last Post: January 19th, 2005, 18:05
  5. VBA to open, print worksheets, close...
    By kimberly in forum EXCEL HELP
    Replies: 2
    Last Post: September 4th, 2004, 12:56

Bookmarks

Posting Permissions

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