Forcing the use of Excel 2003 when activating an OLE object in Word 2003 RRS feed

  • Question

  • I have a function I am attempting to write which cycles through the embedded OLE excel spreadsheets in a Word document and extract information from them.

    My PC has Word and Excel 2003 installed, and when I use the .OLEFormat.Activate code everything works hunkey-dorey.

    However some of my colleagues have both Excel 97 and Excel 2003 installed on their machines. Is there a (VBA based) manner in which I can force Excel 2003 to be used when using .Activate??

    I had tried using .ActivateAs, but it would seem there is a single .ClassType (Excel.Sheet.8) for versions of excel from 97-2003.

    If there is no VBA manner in which I can acheive this, would I have to ensure that the default program for opening Excel was set to 2003 rather than 97?




    Thursday, July 7, 2011 4:12 PM


All replies