calling Excel Library in different version in Access VBA

I am running Access VBA which call Excel function. However, my colleagues use different Excel version. How to achieve calling Excel Library in different version?
howardchingAsked:
Who is Participating?
 
imaki06Connect With a Mentor Commented:
If you want to call specific version of excel, then you can set the version number in the Create-/GetObject call.

Like:
CreateObject("Excel.Application.11")
or:
CreateObject("Excel.Application.12")

If you do not care which version is called, then just use "Excel.Application".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.