Thread: Convert xla add-in to xlam?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default Convert xla add-in to xlam?
In the VB Editor, select the project's ThisWorkbook object, then change the
IsAddIn property to False. This makes the add-in workbook visible in Excel.
Switch to Excel and do Save As choosing the xlam file type.

The xla should still work (mostly, anyway) in 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Richard M" wrote in message
...
I have an add-in in xla format that I want to convert to xlam. Save-as is
unavailable in normal Excel and the VBA editor. How do I do it?


Reply With QuoteReply With Quote