MFC Automation
 

Hi,

I am writing a MFC application that is using automation to write data to an
excel spreadsheet.

The question I have is that when i create the add the class through the
classwizard, it asks me
for the path of the type library i want to use. I am using excel and
obviously there are many versions
of excel. Is there any way when i choose the type library that i can make
it backwards compatible
with previous versions of excel?

e.g I have a version of excel that is installed in directory

C:\ProgramFiles\Microsoft Office\Office10.

Now what happens if i copy my program to another PC that has a different
version of office/excel installed or it is installed in another directory?

How scalable is the automation as i have described above?

Thanks In Advance
Macca