Need values for Excel Constants -- quickly! 
Author Message
 Need values for Excel Constants -- quickly!

I am writing a script in VBScript to automate the creation of charts
from data. (Yes, it has to be VBScript. No, it can't be VBA. I don't
write the specs, I just implement them.) To do this, I *desperately*
need the numeric values for the Excel constants (like 'xlArea'). I
know there is *supposed* to be a 'constants.xls' file, but it is NOT
on my hard drive, our network hard drive, Microsofts Web Site, etc,
etc, etc....

Help? Please?
*----------------------------------------------------*
Evolution doesn't take prisoners:Lizard
Extremism in the defense of liberty is no vice;
Moderation in the pursuit of justice is no virtue:AuH20
http://www.*-*-*.com/



Wed, 18 Jun 1902 08:00:00 GMT  
 Need values for Excel Constants -- quickly!
I don't have the values to hand but why not just knock up a quick VBA macro
under Excel to display the ones you need:

Sub test()
MsgBox xlArea
End Sub

Gives '1' here.

--
Dale Strickland-Clark
Out-Think Ltd, UK
Business Technology Experts


Quote:
> I am writing a script in VBScript to automate the creation of charts
> from data. (Yes, it has to be VBScript. No, it can't be VBA. I don't
> write the specs, I just implement them.) To do this, I *desperately*
> need the numeric values for the Excel constants (like 'xlArea'). I
> know there is *supposed* to be a 'constants.xls' file, but it is NOT
> on my hard drive, our network hard drive, Microsofts Web Site, etc,
> etc, etc....

> Help? Please?
> *----------------------------------------------------*
> Evolution doesn't take prisoners:Lizard
> Extremism in the defense of liberty is no vice;
> Moderation in the pursuit of justice is no virtue:AuH20
> http://www.mrlizard.com



Wed, 18 Jun 1902 08:00:00 GMT  
 Need values for Excel Constants -- quickly!
Lizard,
Here is a link to the fabled file:

http://support.microsoft.com/support/kb/articles/q112/6/71.asp
"Built-in Constants in Visual Basic for Applications" (WC0993)

HTH,
Tom Ogilvy
MVP Excel

Quote:

>I am writing a script in VBScript to automate the creation of charts
>from data. (Yes, it has to be VBScript. No, it can't be VBA. I don't
>write the specs, I just implement them.) To do this, I *desperately*
>need the numeric values for the Excel constants (like 'xlArea'). I
>know there is *supposed* to be a 'constants.xls' file, but it is NOT
>on my hard drive, our network hard drive, Microsofts Web Site, etc,
>etc, etc....

>Help? Please?
>*----------------------------------------------------*
>Evolution doesn't take prisoners:Lizard
>Extremism in the defense of liberty is no vice;
>Moderation in the pursuit of justice is no virtue:AuH20
>http://www.mrlizard.com



Wed, 18 Jun 1902 08:00:00 GMT  
 Need values for Excel Constants -- quickly!
On Thu, 30 Dec 1999 10:39:27 -0000, "Dale Strickland-Clark"

Quote:

>I don't have the values to hand but why not just knock up a quick VBA macro
>under Excel to display the ones you need:

Mostly because I don't know which ones I need/will need yet...:)

*----------------------------------------------------*
Evolution doesn't take prisoners:Lizard
Extremism in the defense of liberty is no vice;
Moderation in the pursuit of justice is no virtue:AuH20
http://www.mrlizard.com



Wed, 18 Jun 1902 08:00:00 GMT  
 Need values for Excel Constants -- quickly!
Constant values can be found with "MsgBox xlConst" in Excel
Constants are also in XLCONST.BAS in Office Developer's Kit 1.0
here are some...

' Excel chart constants
           Const xlArea = 1
            Const xlBar = 2
            Const xlColumn = 3
            Const xlLine = 4
            Const xlPie = 5
            Const xlRadar = -4151
            Const xlXYScatter = -4169
            Const xlCombination = -4111
            Const xl3DArea = -4098
            Const xl3DBar = -4099
            Const xl3DColumn = -4100
            Const xl3DLine = -4101
            Const xl3DPie = -4102
            Const xl3DSurface = -4103
            Const xlDoughnut = -4120

            ' Excel orientation constants:
            Const xlRows = 1
            Const xlColumns = 2

Quote:

>I don't have the values to hand but why not just knock up a quick VBA macro
>under Excel to display the ones you need:

>Sub test()
>MsgBox xlArea
>End Sub

>Gives '1' here.

>--
>Dale Strickland-Clark
>Out-Think Ltd, UK
>Business Technology Experts



>> I am writing a script in VBScript to automate the creation of charts
>> from data. (Yes, it has to be VBScript. No, it can't be VBA. I don't
>> write the specs, I just implement them.) To do this, I *desperately*
>> need the numeric values for the Excel constants (like 'xlArea'). I
>> know there is *supposed* to be a 'constants.xls' file, but it is NOT
>> on my hard drive, our network hard drive, Microsofts Web Site, etc,
>> etc, etc....

>> Help? Please?
>> *----------------------------------------------------*
>> Evolution doesn't take prisoners:Lizard
>> Extremism in the defense of liberty is no vice;
>> Moderation in the pursuit of justice is no virtue:AuH20
>> http://www.mrlizard.com



Wed, 18 Jun 1902 08:00:00 GMT  
 Need values for Excel Constants -- quickly!
Um...8 counting your re-post.



: you can't attach files - zipped or not. and don't post more than once.
: we got this {*filter*}7 times.
:
: keep your question short & in English & you'll get a very fast
: response.
:



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. Help Need Outlook98 again, I lost it and need it quickly

2. Value of vertical alignment constants for Excel 97

3. Excel constant values

4. Excel constant values

5. Value of vertical alignment constants for Excel 97

6. constant value e - were to find and use in excel

7. Getting Name value when value is a constant

8. One Instance of Excel Needs Value of a Cell in Another Instance of Excel

9. Experts needed quickly

10. Need Help quickly.


 
Powered by phpBB® Forum Software © phpBB Group