Convert XLA to XLS

raj

New Member
Joined
Mar 12, 2002
Messages
4
How do i convert an excel add in to a normal excel file ?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
On 2002-03-13 16:53, raj wrote:
How do i convert an excel add in to a normal excel file ?

Press Alt F11
Press Ctrl R
In the window pane click the
"Thisworkbook" object
Press F4
Scroll down this window until you see
IsAddin
Change the property to False

Now save the workbook as xls



Ivan
 
Upvote 0
thanks for the valuable input.
how do i get through password protection for an XLA as i do not know the password and the employee has left ? regards, raj
 
Upvote 0
On 2002-03-14 08:19, raj wrote:
thanks for the valuable input.
how do i get through password protection for an XLA as i do not know the password and the employee has left ? regards, raj

You'll have to get a password *******
Do a search online for one...there are many

Ivan
 
Upvote 0
I have similar problem where Excel converted the main file into xlam format instead of my UDF file,
the file does not open, neither can be Added in,
Mainfile was a large 2MB file and now only reduced to 12 KB
Is there anyway to recover the original file / restore to xls format.

Thanks,
Imran
 
Upvote 0
Hi!

Sorry, but my english is not too good. And sorry for that I can't the perfect forum...

I have an interesting problem: I would like to make an automatic save on an xls in every minutes with excel 2003. I want to my output file format are xls or txt. I tried the excel's automatic save function, but I only did XAR file formats.

Please help me, how can I do that without non-free program.

Thank you very much in anticipation!

Balazs
http://szotar.sztaki.hu/dict_search...NG:HUN:EngHunDict&W=thank you in anticipation
 
Upvote 0

Forum statistics

Threads
1,213,533
Messages
6,114,179
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top