Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)
This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really tricky one.
Follow the below Steps to do the same:
Double Click on .xla or .xlam file (Refer Pic 1)
File will open as shown in the below Pic 2
Now Press ALT+F11 (Refer Pic 3) (Provide your password if Password protected)
Now Expand Microsoft Excel Objects as shown in below picture and Select This Workbook
Press ALT + F4 to see the property window of the “ThisWorkBook” Object
Set the IsAddin property to FALSE as shown in the below pic
Now you can see your Workbook. Save it as .xls, .xlsx or .xlsm.
Cheers You are done !!
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON'T MISS ANY NEW ARTICLE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-Box