I've used Automation to format an Excel worksheet, using the Excel 8 type libray so I can target Office versions 97 and later (or so I thought). I've used the Range::Replace method and when running on a system with Office XP we get the ole error 8002000e Invalid number of parameters, because the XP version of the Replace function takes 8 parameters, whereas the 97 version takes 10.
Quoting from http://support.microsoft.com/kb/244167/EN-US/
"Office applications that are tested and compiled with earlier versions of a type library continue to work, unchanged, when end users of your product upgrade their Office installations to a more recent version. In this way Office provides backward compatibility." Apparently not.
Early or late binding is no help here - they've broken the interface. As far as I can see I'll have to pick one version of Office to support - or am I missing something?
Any help is appreciated.