I spent years developing a software applicaitonthat has extra menu
items at the top, and it works, finally, really well...on Excel 2003.
Along comes 2007, and the add-ins now are hidden from the soccer moms
that use the program in an obscure 'add-on' box. Is there any way that
I can detect that someone using my program has Excel 2007 and display
special help messages or something so that I do not have to rewrite
everything? I have seen ways to change the ribbon back to the 2003
headers, but if the user is familiar with the ribbon concept, that
could even cause more confusion in the future. Thanks in advance
(again).

You can test it with

If Val(Application.Version) < 12 Then
'97-2003
Else
'2007
End If

I use it for example on this page
http://www.rondebruin.nl/mail/folder1/mail2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<(E-Mail Removed)> wrote in message news:f98060c1-8193-4dc2-9450-(E-Mail Removed)...
>I spent years developing a software applicaitonthat has extra menu
> items at the top, and it works, finally, really well...on Excel 2003.
> Along comes 2007, and the add-ins now are hidden from the soccer moms
> that use the program in an obscure 'add-on' box. Is there any way that
> I can detect that someone using my program has Excel 2007 and display
> special help messages or something so that I do not have to rewrite
> everything? I have seen ways to change the ribbon back to the 2003
> headers, but if the user is familiar with the ribbon concept, that
> could even cause more confusion in the future. Thanks in advance
> (again).

On Sep 15, 11:47*am, "RJQ...@gmail.com" <RJQ...@gmail.com> wrote:
> I spent years developing a software applicaitonthat has extra menu
> items at the top, and it works, finally, really well...on Excel 2003.
> Along comes 2007, and the add-ins now are hidden from the soccer moms
> that use the program in an obscure 'add-on' box. Is there any way that
> I can detect that someone using my program has Excel 2007 and display
> special help messages or something so that I do not have to rewrite
> everything? *I have seen ways to change the ribbon back to the 2003
> headers, but if the user is familiar with the ribbon concept, that
> could even cause more confusion in the future. *Thanks in advance
> (again).

Hi RJQMAN:

I got this little bit of code from Ron de Bruin, it tests what version
of Excel is being used, in order to adjust the save method but I am
sure you can adapt this to your needs.

'Determine the Excel version and file extension/format
If Val(Application.VERSION) < 12 Then
'You use Excel 97-2003
FileExtStr = ".xls": FileFormatNum = -4143
Else
'You use Excel 2007
If SrcBk.Parent.FileFormat = 56 Then
FileExtStr = ".xls": FileFormatNum = 56
Else
FileExtStr = ".xlsx": FileFormatNum = 51
End If
End If


Steven

Looks like you beat me to it Ron.


Steven

On Sep 15, 11:54*am, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> You can test it with
>
> *If Val(Application.Version) < 12 Then
> * * '97-2003
> Else
> * * '2007
> End If
>
> I use it for example on this pagehttp://www.rondebruin.nl/mail/folder1/mail2.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> <RJQ...@gmail.com> wrote in messagenews:f98060c1-8193-4dc2-9450-(E-Mail Removed)...
> >I spent years developing a software applicaitonthat has extra menu
> > items at the top, and it works, finally, really well...on Excel 2003.
> > Along comes 2007, and the add-ins now are hidden from the soccer moms
> > that use the program in an obscure 'add-on' box. Is there any way that
> > I can detect that someone using my program has Excel 2007 and display
> > special help messages or something so that I do not have to rewrite
> > everything? *I have seen ways to change the ribbon back to the 2003
> > headers, but if the user is familiar with the ribbon concept, that
> > could even cause more confusion in the future. *Thanks in advance
> > (again).

On Sep 15, 11:54*am, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> You can test it with
>
> *If Val(Application.Version) < 12 Then
> * * '97-2003
> Else
> * * '2007
> End If
>
> I use it for example on this pagehttp://www.rondebruin.nl/mail/folder1/mail2.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
> <RJQ...@gmail.com> wrote in messagenews:f98060c1-8193-4dc2-9450-(E-Mail Removed)...
> >I spent years developing a software applicaitonthat has extra menu
> > items at the top, and it works, finally, really well...on Excel 2003.
> > Along comes 2007, and the add-ins now are hidden from the soccer moms
> > that use the program in an obscure 'add-on' box. Is there any way that
> > I can detect that someone using my program has Excel 2007 and display
> > special help messages or something so that I do not have to rewrite
> > everything? *I have seen ways to change the ribbon back to the 2003
> > headers, but if the user is familiar with the ribbon concept, that
> > could even cause more confusion in the future. *Thanks in advance
> > (again).- Hide quoted text -
>
> - Show quoted text -

Thanks for the help. It is much appreciated from both of the
responders. You type faster than I can think!!

Hi Steven

Better two answers for the OP then no answer

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<(E-Mail Removed)> wrote in message news:20d2aeb2-31ac-4a33-b886-(E-Mail Removed)...
Looks like you beat me to it Ron.


Steven

On Sep 15, 11:54 am, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> You can test it with
>
> If Val(Application.Version) < 12 Then
> '97-2003
> Else
> '2007
> End If
>
> I use it for example on this pagehttp://www.rondebruin.nl/mail/folder1/mail2.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> <RJQ...@gmail.com> wrote in messagenews:f98060c1-8193-4dc2-9450-(E-Mail Removed)...
> >I spent years developing a software applicaitonthat has extra menu
> > items at the top, and it works, finally, really well...on Excel 2003.
> > Along comes 2007, and the add-ins now are hidden from the soccer moms
> > that use the program in an obscure 'add-on' box. Is there any way that
> > I can detect that someone using my program has Excel 2007 and display
> > special help messages or something so that I do not have to rewrite
> > everything? I have seen ways to change the ribbon back to the 2003
> > headers, but if the user is familiar with the ribbon concept, that
> > could even cause more confusion in the future. Thanks in advance
> > (again).