?
Solved

calling Excel Library in different version in Access VBA

Posted on 2011-05-05
1
Medium Priority
?
290 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:howardching
1 Comment
 
LVL 3

Accepted Solution

by:
imaki06 earned 2000 total points
ID: 35704007
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question