Using (what library needs referenced)

Posted on 2010-01-03
Last Modified: 2013-12-25
I am attempting to use some borrowed code in VBA with Access 2007.  One of the lines of code is Application.International (xlDecimalSeparator).  However, when I compile, it errors out on this line saying Method or Data Member not found.  I have set a reference to the Microsoft Excel 12.0 Object Library, but obviously that wasn't the correct one.  

Can anyone tell me what Library I need to be referencing (if that indeed is my problem)?
Question by:MsSherry
    LVL 1

    Accepted Solution

    I am assuming that you are trying to set the decimal separator in Excel. What you need to do first, is tell Access what "application" is... Like this:

    Dim app as Excel.Application
    app = new Excel.Application
    app.International (xlDecimalSeparator) = whatever.

    If this is NOT what you are trying to do, please provide more of your code.

    Author Closing Comment

    Awesome!  Thanks for the quick response.  I am obviously a novice when it comes to using functions outside of Access.   Thanks for teaching me how :)

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now