Add-Ins Question
 

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

http://www.contextures.com/xlToolbar...100000000#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

Add-Ins Question
 

Hi CWillis

Are you sure?

It is the last item in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl



"CWillis" wrote in message ...
I am trying to create an Add-In following Dave Peterson's steps:

http://www.contextures.com/xlToolbar...100000000#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

Add-Ins Question
 

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" wrote:

Hi CWillis

Are you sure?

It is the last item in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl



"CWillis" wrote in message ...
I am trying to create an Add-In following Dave Peterson's steps:

http://www.contextures.com/xlToolbar...100000000#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

Add-Ins Question
 

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"CWillis" wrote in message ...
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" wrote:

Hi CWillis

Are you sure?

It is the last item in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl



"CWillis" wrote in message ...
I am trying to create an Add-In following Dave Peterson's steps:

http://www.contextures.com/xlToolbar...100000000#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

Add-Ins Question
 

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.)

Ron de Bruin wrote:

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"CWillis" wrote in message ...
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" wrote:

Hi CWillis

Are you sure?

It is the last item in the dropdown

--
Regards Ron de Bruin
http://www.rondebruin.nl



"CWillis" wrote in message ...
I am trying to create an Add-In following Dave Peterson's steps:

http://www.contextures.com/xlToolbar...100000000#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




--

Dave Peterson

Add-Ins Question
 

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.



CWillis wrote:

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

http://www.contextures.com/xlToolbar...100000000#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

--

Dave Peterson

Add-Ins Question
 

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" wrote:

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.



CWillis wrote:

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

http://www.contextures.com/xlToolbar...100000000#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

--

Dave Peterson

Add-Ins Question
 

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

CWillis wrote:

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" wrote:

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.



CWillis wrote:

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

http://www.contextures.com/xlToolbar...100000000#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

--

Dave Peterson


--

Dave Peterson