Hello:


Everything was fine until I tried my code on another laptop with Excel 2007
and the new file extensions. Trying to get my VB code to tell the difference
between Excel 2003 or 2007. Is there an API or Function call that can do this?

Thanks in advance for any and all assistance.

Assuming you are already automating an instance on Excel

xlVer = Val(Left$(xlApp.Version, 2))

8, 9, 10, 11, 12 ' next one will be 14
97, 2000, 2002, 2003, 2007

If you are not automating Excel, you can get the "current Version" from the
registry or search examples of FindExecutable in this group.

If you are working with Excel's object model there might be several other
things you might need to do differently in 2007

Regards,
Peter T


Show quoteHide quote

10_a_c <1***@discussions.microsoft.com>'s wild thoughts were
released on Sat, 23 May 2009 22:17:04 -0700 bearing the
following fruit:

I'd like to see the code because it shouldn't make a
difference (as far as VB is concerend) what the file
extension is.

Help with a bit of maths
OT: The bloated get bloatier
MBF to IEEE (Beg. Q)
write a bitmap into an array of picture boxes
Changing a property on a control
Toolbar Dilema
Where are the VB6 Reference entries kept?
calling (and deleting) a string from an unmanaged dll
Vista and AutoRedraw
Phone system integrated in vb app