>>Hi. To open Excel, I give a command like:
>>
>>
>>loExcel = CreateObject("Excel.Application")
>>
>>
>>On one machine, there are two versions of Excel installed; I think it's Excel 2003 and 2007. Is there a way to control what version of Excel will be opened?
>>
>>This is actually solved already, in the sense that the corresponding user decided to remove the old version of Excel. But I was still curious whether there is any way to control this.
>
>you could save registry status, set values to point to old versions, call and reset afterwards. No, not reccommended, not even experiments ;-)
>Could work with older DDE - don't you set a path there to the corresponding exe if needed ?
I don't know about paths; all I ever did was invoke Excel with the
CreateObject("Excel.Application") instruction; I never worried about where it might be installed.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)