Can a spreadsheet tell which version of Excel has opened it? 4

[lionelhill]

Hi...
I'm working in a mixed environment of Excel2003 and Excel2007, but most of my Excel2003-using clients can open .xlsx files, with automated file conversion.

When they do so, they miss out on any 2007-specific features. Obviously Excel2003 warns them, but the message is in geek-speak and not very specific.

I would like to add to my spreadsheets a dire and more specific warning, visible only when the sheet is opened in Excel2003, which can alert users to the things most likely to mislead them (conditional formatting that will come out completely different to that described in associated documentation, etc.). So I'm looking for an Excel2003 function, if any exists, that tells me the current version of Excel. Alternatively if it's possible in VBA, I can repost there.

Many thanks in advance! Copious stars available as usual...

 

[HarleyQuinn]

Using VBA you can use Application.Version

Hope this helps

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com

 

[SkipVought]

hi,

Sub WhatVers()
  MsgBox Application.Version
End Sub

Add control logic as needed. Post VBA questions in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

Thanks for the instant response! I had hoped to avoid VBA, but if two experts tell me that's the way to go, I go happy.

 

[combo]

You can too directly:
=INFO("release")

combo

 

[SkipVought]

I know that I should have checked the 'Information' category! ==>*

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[combo]

So I did !

combo

 

[lionelhill]

Thanks combo,
That is stunning.