Creating/Saving an .xla file

A

aniamc

Im trying to save a modified .xla file. After closing, it does not sav
any changes.
Then I tried to save any excel workbook as an .xla file but Im missin
the type Microsoft Excel Add-in (.xla) and I have an active workshee
in the workbook.
Within VBE - Im missing the IsAddIn property. It seems anything to d
with add-ins is missing.
Is there an option I need to turn on in excel in order to creat
addins?

Im running Excel 2000 on Windows 2000.

Thanks for your help.

Ani
 
B

Bob Phillips

What do you mean

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Aria,

What do you mean by 'Im missing the type Microsoft Excel Add-in (.xla)' ?

And are you saying that you laod the add-in and it has an IsAddIn property
of False?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
A

aniamc

I mean I am literally missing the the Excel Add-In type as a choice t
Save my workbook as an .xla file rather than an .xls.
And I am literally missing the IsAddIn property in the propertie
window in VBE. Does not exist.
Im not loading any add-in. Im trying to create one.
This concludes that somehow Im missing the Add-In functionality withi
Excel
 
B

Bob Phillips

Addins are the very last item in the Save as type dropdown, so yuou need to
scroll all the way down.

And you have to select the ThisWorkbok object to see the IsAddIn property.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top