Excel.Application

[smoothdurban]

Hey All

Using Diadem 2017 64 bit and my team has recently updated our version of excel to 64 bit which is causing some problems

I have excel 2010 installed on my machine and when I create an activeX object of excel it defaults to the version 16 which is a 64 bit version

I would like Diadem to open the 2010 version of excel

The following code should open the 2010 version of excel;

Dim excel

Set excel = CreateObject("Excel.Application.14)

however when I return the version number I get 16.0

Call msgbox(excel.version)

Anyway I can force Diadem to open 2010 version of excel?

Thanks

[smoothdurban]

I am curious of anyone else can try this and see if the same behavior is exhibited 

[smoothdurban]

Anyone? Try it!  its fun!

[Walter_Rick]

Hello Tim,

I don't have an old Excel version, and so I can't reproduce this behavior, unfortunately. But anyway, "CreateObject" is a VBS (Microsoft) command. And so I can't help in this case. However, you could discuss the magic behind the version change with Microsoft.

Greetings

Walter