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!

try using the value of the constant instead:

? xlVAlignCenter
-4108


--
Regards,
Tom Ogilvy


"dutchie" wrote:

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!

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!