Add In target directories
 

I just created an Add-in. When I saved the the xls file
as an xla file, Excel automatically saved it in

C\Douments and Setting\My name\Application
Data\Microsoft\Add Ins

I am trying to update the XLA but cannot seem to find this
directory in My Computer. Perhaps there is limited access
to the folder through my IS department. Although I was
able to create the XLA in the folder from Excel.

Is it possible to convert the XLA file back to an XLS file
so that I can make the changes, and then save it back to
an XLA file (in Excel) which will then be automatically
saved in the directory above?

Add In target directories
 

Hi

This is a hidden folder
ToolsFolder options..View and change it

Is it possible to convert the XLA file back to an XLS file
Selcet your Add-in thisworkbook module in the VBA editor
In the properties(F4) set IsAddin to false


--
Regards Ron de Bruin
http://www.rondebruin.nl



"ExcelMonkey" wrote in message ...
I just created an Add-in. When I saved the the xls file
as an xla file, Excel automatically saved it in

C\Douments and Setting\My name\Application
Data\Microsoft\Add Ins

I am trying to update the XLA but cannot seem to find this
directory in My Computer. Perhaps there is limited access
to the folder through my IS department. Although I was
able to create the XLA in the folder from Excel.

Is it possible to convert the XLA file back to an XLS file
so that I can make the changes, and then save it back to
an XLA file (in Excel) which will then be automatically
saved in the directory above?