automation q: center text in a spreadsheet cell

[kim]

I'm coding a process in Access that will take the data in
the database, manipulate it, and write a spreadsheet using
automation. I would like to center the text of some cells
on the spreadsheet, but I don't know how to do this. I
assumed it would be "object.Alignment = 2" (w/o quotes),
but that isn't working for me and I get a "Run-time
error '438' Object doesn't support this property or
method" message. The actual line of code is:

objExcel.Cells(5, 3).Alignment = 2

Any help anyone can provide me would be much appreciated.


kim

 

[Ken Snell]

objExcel.Cells(5, 3).HorizontalAlignment=xlCenter

assuming that objExcel is a Worksheet object.