Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Algin left the value in export excel?
Message
From
20/04/2011 08:45:48
 
 
To
19/04/2011 21:25:05
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01507788
Message ID:
01507898
Views:
28
When I am not sure of a value of an Excel constant, I go to Excel Macro (Visual Basic Window) and in the Immediate Window you can type:
?Constantname
and it return the value in the window.

See screenshot.

>ok la ~~~ thank for your help ........
>but oRng.HorizontalAlignment = 1 not equal to algin left?
>
>
>oRng.HorizontalAlignment = 4               < equal to algin  right?
>oRng.VerticalAlignment = 4
>
>
>oRng.HorizontalAlignment = 3                 < equal to algin center?
> oRng.VerticalAlignment = 3
>
>
>
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform