Info Release in Excel in Visual Basic 1

[senators40]

I know the function to determine the version of excel the user is using

It is =Info("Release") in the excel cells as a function.

How do I convert that into visual basic.

When I record macro and put the function into the cell I get the following

Sub Macro2()
ActiveCell.FormulaR1C1 = "=INFO(""release"")"
End Sub

What I would like to do is state if the user is using Excel 2002 (which is returns version 10) then do something - if the user is using Excel 2000 (which is version 9) then do something else

I would also like to put it in one step so I don't have to enter the function on the sheet and then state if activecell = 10 then etc. If that is not possible then also please let me know.

Any Help would be appreciated

Thanks,

Jeff

 

[chandlm]

debug.print application.version

Matt

 

[SkipVought]

senators40,

I notice that you've been a member for 5 1/2 years and have posted several dozen questions, the answers to which I would have hoped, provided you with valuable information.

However, I also notice that you have NOT ONCE responded to...
[blue]
Thank contributor
for this valuable post!
[/blue]
The little purple stars are identifiers for other members who browse for helpful information.

They also function as "Thank You's" to members provideing such information.

And finally they indentify the poster, that's YOU, as someone who in not singy with visual expressions of gratitude.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[senators40]

Hi,

I do appreciate all the good work that everyone who contributes to the answers to questions and I have told many people about the good work that this site provides.

I do appologize that I didn't send thank you's more often - it is an oversight which I will not do again.

Sorry for not stating this earlier to the various posts.

Jeff

 

[electricpete]

There is also the link you can click at the end of Matt's post which would award him an LPS (little purple star)