Quote Originally Posted by firefytr
No Ken, the VB version is still 6, you must only do a version check. Excel 97 was still based on VB5, hence the compilation check.
I realize that. The question really was "is there any way we can create a conditional for 2007". I didn't think testing on version would work, but then I haven't played with conditional compliation much.

Quote Originally Posted by firefytr
And as sad as it is about FileSearch, I must abandon that as well. I prefer to use code that is compatible in many versions. I hate narrowing the margin.
I'll tell you... if I had to convert a huge number of files to work with 2007, I'd do it. Then go back and modify them later... if I felt I needed to. As Bob had said (or eluded to) before, I don't see why it's any less valid a solution though.