Solved

XLconstant

Posted on 2003-10-31
1
218 Views
Last Modified: 2009-12-16
I'd like to know how retrieve name of XLconstant.
For example xlPie=5 and I want to retrieve xlPie by giving 5, like XLcst(5)="xlPie"
0
Comment
Question by:meciab
1 Comment
 
LVL 2

Accepted Solution

by:
wellilein earned 150 total points
ID: 9657664
I thinks these are Excel constants, not Access, am I right?
It's not possible to reverse the constants, because only the names are unique.

Some examples:
xlAllAtOnce = 2
xlAllChanges = 2
xlAdd = 2
xlArrowHeadStyleOpen = 2
Which one should be returned by asking for XLcst(2)?

If you want to reverse it anyway, you could use the list from http://techsupt.windowware.com/TS/T000001033005F9.html
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

708 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

16 Experts available now in Live!

Get 1:1 Help Now