Setting alignment in excel via vb .net

[dutchie]

Hello -

I'm loading data from SQL Server 2000 via a web app written in
vb .net. I have no problem getting the data in the cells I want,
saving the excel file, and opening it in the browser. However, when I
try to format the cells, I'm getting this error:

"Public member 'XlVAlign' on type 'ApplicationClass' not found."

Here is the code I copied and pasted from examples I found online:
--
With excel.Range("A1", "D1")
.VerticalAlignment = excel.XlVAlign.xlVAlignCenter
End With
--
If it helps clarify anything, when I type in the line
".VerticalAlignment = excel." I don't have any options listed that
start with the letter "X".

I use the line
--
excel.Cells(rowIndex, colIndex).numberformat = "$#,##0.00"
--
and that works fine.

As I've said, the process worked great until I tried to pretty it up
by formatting.

Any help would be appreciated! If I am not including enough
information, or if this is not the appropriate group to post to,
please let me know.

Thanks!

 

[Tom Ogilvy]

try using the value of the constant instead:

? xlVAlignCenter
-4108

 

[dutchie]

Wow, that worked. Thanks!

This still makes me think I'm missing a reference to a dll or
something, which bothers me, but if I have to use the values I will.

Thanks again!