Excel constant ?

[viettla]

Hi all,
I have msExcel9.h file but i can not find some constants in it. Does someone know value of constants as following
xlBorderLineStyleNone
xlBorderLineStyleContinuous
xlBorderLineStyleDash
xlThin
xlThick
thank you very much

Viet

 

[Mike Lewis]

Viet,

The best way to find the values for Excel constants is as follows:

- Launch Excel

- Tools / Macros / Visual Basic Editor

- View / Object Browser

- Select Excel in the drop-down in the top-left corner

- Search for the contstant in question

- When you find it, highlight it and glance at the foot of the screen. That will tell you its value.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[viettla]

Thank Mike,
I did it but search result was "No Items Found" although I selected "all libraries"


Viet

 

[Mike Gagnon]

viettla

Have you tried the suggestion in faq184-4248?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Viet,

You're right. I couldn't find the border line styles either. But xlThin and xlThick are 2 adnd 4 respectively.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk