for excel automation

[Gerald Mercet]

Hello, In the samples given on microsoft support (Q178749: HOWTO Create automation project using MFC and a type library) we have to select Microsoft Excel 8.0 Object Library if we use excel automation. But what could i do if i have office XP on my workstation? thanks in advance gerald

[Lost User]

I assume you are using VC7 to import library (Excel in your case) #import "libid:\<>" if you want to be more specific with the version #import "libid:\<>" version("x.x") From what I saw MSOffice libraries are backward compatible so it should work, even though by rules of COM major version change should be treated as separate library.

[Giles]

If you target the Excel 8.0 library and build your exe, it will still work on different machines with Office 2000 and Office XP, though it does not seem to work in reverse. i.e. build for the 10.0 library and run it on a machine with Excel 97.

[Gerald Mercet]

no i use VC++ 6.0

[AlexO]

then use #import "excel8.olb" And you will have to carry excel8.olb as a part of your build. I am not sure if it is legal though, you might have to have Excel8 on your build machine, check the user agreement.