How can I open EXCEL 2010 from catia vba?

[Ruky]

I know CreateObject("EXCEL.Application") works well with excel 2003. But I want to open excel 2010 instead of 2003 (I have both in my machine).

Tried CreateObject("EXCEL2010.Application") and CreateObject("2010EXCEL.Application")---both did not work.

 

[ferdo]

Hi

CreateObject("EXCEL.Application.14")


Regards
Fernando

https://picasaweb.google.com/102257836106335725208

https://picasaweb.google.com/103462806772634246699/

 

[Ruky]

Hi ferdo,

Thanks for this. Iam pretty much new to Catia VBA programming. I do well in excel VBA but translating my skills to CATvba has been a challenge. I have another thread in the forums. I posted the code that I am working on would you mind taking a look at it also?

thread560-338995