From: Karl E. Peterson on 6 May 2010 18:59 Tony Jollans wrote: >> In other words, on a system with Office 2007 installed, these statements >> are equivalent: >> >> Set obj = CreateObject("Excel.Application") >> Set obj = CreateObject("Excel.Application.12") >> >> But there's no reason you couldn't use this instead, if you wanted to call >> up Office 2003: >> >> Set obj = CreateObject("Excel.Application.11") >> >> Make sense? > > It makes perfect sense. Unfortunately it doesn't work :-( Office does its own > thing (as usual) and the CLSID under Excel.Application.11 and > Excel.Application.12 is the same. Hmmmm, this could be why I've always heard/understood that multiple side-by-side installations didn't work. > The only way (I know) to guarantee getting > a particular version is to Shell the executable. I suppose you could play around with altering the incorrect CLSID entry? (Unless, and this would be truly evil, unless those idiots used the same CLSID for both versions???) -- ..NET: It's About Trust! http://vfred.mvps.org |