MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Xla problem


Posted by Herman on July 11, 2001 2:18 AM

I have an addin that has several macro's in it
the macro builds a menu and it gets his items from a sheet in the xla
how can i see that sheet or can i convert the xla back to an xls sheet.

please if someone has a converter or knows how to see the sheets in the xla file mail me or write a reply


Posted by Ivan F Moala on July 11, 2001 2:56 AM

Do you have access to the addins code ??
ie. is it password protected ??
If not then set the Thisworkbook Isaddin property
to False. You should be able to view the sheets
and make amendments. Don't forget to save and then
change it back to true.

If it is password protected then all you can do is see the sheets by running this code.

Sub GetXLA_Sheets()

Set xlaWB = Workbooks("TestXLA.xla")

For Each xlaSh In xlaWB.Sheets
xlaSh.Visible = True
xlaSh.Copy After:=ThisWorkbook.Sheets(Sheets.Count)
Next

End Sub

Change TestXLA.xla to the name of the addin.


Ivan

Posted by Malc on July 11, 2001 2:56 AM

xla files are't that much different from xls files except the xla is normally a database and template. Files opened and saved as from an xla have take all the macros and formatting in them. You'll probably find the macro makes hidden sheets visible and gets or posts data then hides them again. Try format sheets unhide or if that doesn't work click esc edit while the macro is running and see if you can fiqure out what's going on

Posted by Herman on July 11, 2001 2:58 AM


i have access to the xla code, but in the xla code i have excell object and the one with the sheet is password protected..i will try it with your code

thanx

Posted by Herman on July 11, 2001 3:02 AM


i have access to the xla code, but in the xla code i have excell object and the one with the sheet is password protected..i will try it with your code

it did give me the sheets in the workbook but all i see is a grey sheet with no text on it
when i manually enter a cell and column like r2c3
then i can see in the formulabar what is in it.
how can i make al my cells visible.

??
thanx

Posted by Ivan F Moala on July 11, 2001 3:16 AM

Click on the intersection of the cells @ the top
The select Format /Row /unhide
format / column / unhide


Ivan

Posted by Herman W on July 11, 2001 3:36 AM


i dont even have rows or columns with intersections only one grey screen.
but when i manually give in row 10 column 10 then i see in the formulabar what is in it


Posted by Ivan F Moala on July 11, 2001 3:47 AM

Press F5
Type in Iv256
Now press F5 again
Type in A1
Hold shift key
and press enter
Click Format / column / unhide
All columns should be unhidden
Do the same with the rows except last row
address is A65536


Ivan


Posted by Herman w on July 11, 2001 4:41 AM


i tried but i doesn't work, if i insert colums i can select those but my cursor won't go anyfurther then the just inserted column i can't select the column next to it it seems it's blocking the cell for selecting

strange but true