Using application.international (what library needs referenced)

Posted on 2010-01-03
Medium Priority
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

Accepted Solution

VeeVan earned 2000 total points
ID: 26166524
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

ID: 31672171
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

839 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