View Full Version : Update the VBA code in a XLA file
Jeevie
01-02-2012, 08:30 AM
Hi All
I am unable to update the VBA code in an XLA file. After closing the file the changes are lost.
Can someone help ?
Thanks in advance.
JKwan
01-02-2012, 09:09 AM
This may sound dumb, but did you save the xla file?
Jeevie
01-02-2012, 11:22 AM
Yeah, i have the existing xla file where i need to make some changes. But even after making the changes, when i reopen, the updates are not visible.
Paul_Hossler
01-02-2012, 07:18 PM
I am assuming that this is an 2003 XLA, I don't have my copies any more so this is from memory
You have to make it a normal .xls file first
I think in the VBE in the Properties window
If you select the XLA, there's a 'IsAddin' property that you can change
If I remember right, that will make it just like any hidden workbook that you can un-hide it as you would any normal workbook
Then save is as FileType = xls
Make your changes and save the XLS version, and then FileSaveAs an XLA version
Paul
Bob Phillips
01-03-2012, 06:22 AM
The property Paul refers to is in the ThisWorkbook object.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.