[RESOLVED] [Excel] Detecting Excel Version with VBA

Is there a way to detect which version of Excel is running from within a Macro?

What I need to do it get some code to run in both 2003 and 2007. Problem is that at least two sections of the code won't run in one version or the other, so I need to detect which version it is to get the code to run properly.

example:

if Excel2007 then
2007 code runs here
else
2003 code runs here
end if

Any suggestions?

Thanks
datapard

application.version

Quote:

---

Originally Posted by westconn1

application.version

---

Thanks westconn1. Do you happen to know what the designators for 2003 and 2007 are?

Thanks again,
datapard

Edited:

Never mind, I just found the answer. Thank you for your assistance. :)

datapard