DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel.Application

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

 

Tim
0 Kudos
Message 1 of 4
(948 Views)

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

Tim
0 Kudos
Message 2 of 4
(857 Views)

Anyone? Try it!  its fun!

Tim
0 Kudos
Message 3 of 4
(789 Views)

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

0 Kudos
Message 4 of 4
(771 Views)