Add-Ins Question

[Guest]

I am trying to create an Add-In following Dave Peterson's steps:

http://www.contextures.com/xlToolbar01.html-CIPCZQX0106450e01=0000d1011c00adf100000000#Save

However, I do not have the "Save as type: Microsoft Office Excel Add-In
(*.xla)" option under Save As. I am using excel 2002. Is this available
with this version?

Thanks,
Chris

 

[Ron de Bruin]

Hi CWillis

Are you sure?

It is the last item in the dropdown

 

[Guest]

I don't see it in Excel or Word (both 2002). Neither does a co-worker. That
doesn't mean it isn't there though. Is there anything we could have done to
turn it off or something we could do to turn it on? I have 26 options in my
pull-down Save as menu. The last is "DIF".

 

[Ron de Bruin]

Sorry, I never read anything about this but maybe Dave have ?

 

[Dave Peterson]

I've never seen it either.

I hate to suggest a re-install, but maybe????

(I was hoping someone who had seen this would chime in.)

 

[Dave Peterson]

Maybe you could use a little macro to save the file as an addin.

Someone just asked a very similar question and this was my response:

I'd use something like:

Option Explicit
Sub testme()
Dim fName As String
fName = Application.StartupPath & "\" & "custom.xla"
With ThisWorkbook
.IsAddin = True
Application.DisplayAlerts = False
.SaveAs Filename:=fName
Application.DisplayAlerts = True
End With
End Sub


Don't store the .xls in that XLStart folder, either.

 

[Guest]

Thanks Dave, that worked. That navigation toolbar is exactly what I needed.
Well, I really need to be able to stack my tabs at the bottom, but this is
the best possible alternative. Thanks again.

 

[Dave Peterson]

I'd still look for the solution to the real problem though. Something ain't
right.