Using createobject Excel application to create excel 2007 application

Question

I have 2 excel versions installed on my system. 2007 and 365.

when using

function open1()

set h = createobject("Excel.application")
h.visible = true
h.workbooks.add

end function

Excel 365 opened up when I wanted to open excel 2007.

I tried searching for a solution to this. but could not find any similar case.

Is there any specific way I can open excel 2007 application?

Answer 1

Try the next adapted way. No need to function, if it does not return anything:

Sub open1()
  dim h as Object

  set h = createObject("Excel.application.12")
  h.visible = true
  h.workbooks.add
end Sub

To use the alternate version, try createObject ("Excel.application.16"). If not, the default version is picked up automatically...

Since I have never needed two different versions, I am unable to test it. However, I used Corel versions, which operate in a similar manner. In the case of Corel, there are certain variations between the versions that affect how the same thing is done. I created some programs, and I had to update them all in the event that any changes were necessary.