Constants value ( xlVertical) 
Author Message
 Constants value ( xlVertical)

Hello

I am facing some problem with Excel / Word 97 Automation
with OLE, PB7.0.3, & EBF, for   Windows 98, 2000, & XP.

You can tell me example in VB i will convert it in PB.

 Set MyStyle = ThisWorkbook.Styles.Add(Name:="Test")
  MyStyle.Orientation = xlVertical

I need value of this xlVertical , so that i can put it in
PB. because PB don't Understand xlVertical, so please tell
me value of xlVertical, and also tell me from where i can
get list of it becuause I need value of all other constant
also.




Mon, 07 Nov 2005 07:48:02 GMT  
 Constants value ( xlVertical)
Tom

Open the VBE, go to the Immediate Window and type

?xlVertical

you will get -4166.

--
{*filter*} Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.


Quote:
> Hello

> I am facing some problem with Excel / Word 97 Automation
> with OLE, PB7.0.3, & EBF, for   Windows 98, 2000, & XP.

> You can tell me example in VB i will convert it in PB.

>  Set MyStyle = ThisWorkbook.Styles.Add(Name:="Test")
>   MyStyle.Orientation = xlVertical

> I need value of this xlVertical , so that i can put it in
> PB. because PB don't Understand xlVertical, so please tell
> me value of xlVertical, and also tell me from where i can
> get list of it becuause I need value of all other constant
> also.





Mon, 07 Nov 2005 22:55:59 GMT  
 Constants value ( xlVertical)
In the Visual Basic editor, go to the Immediate Window and type a question
mark followed by the name of the constant. Then press Enter and it will give
you the value. Repeat as necessary. e.g.

?xlvertical
-4166

Ted Longstaffe
Vancouver, Canada


Quote:
> Hello

> I am facing some problem with Excel / Word 97 Automation
> with OLE, PB7.0.3, & EBF, for   Windows 98, 2000, & XP.

> You can tell me example in VB i will convert it in PB.

>  Set MyStyle = ThisWorkbook.Styles.Add(Name:="Test")
>   MyStyle.Orientation = xlVertical

> I need value of this xlVertical , so that i can put it in
> PB. because PB don't Understand xlVertical, so please tell
> me value of xlVertical, and also tell me from where i can
> get list of it becuause I need value of all other constant
> also.





Wed, 09 Nov 2005 07:33:45 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Getting Name value when value is a constant

2. Get str constant to constant

3. Constant's Value

4. Get named constants value

5. Get value of VBA constant in another file?

6. HELP! saveas fileformat property constants: incorrect value

7. Retreive value of constant range name

8. Get Named constants value

9. Value of vertical alignment constants for Excel 97

10. Getting constant values into a worksheet


 
Powered by phpBB® Forum Software © phpBB Group