Excel Formatting Cells Using VB code
I just recorded a macro and go the following:
Cells.Select
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlTop
.WrapText = True
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With
If that's what your asking, hope this helps since I'm not sure about the
HTML part...
"Andrew Price" wrote in message
...
Am fairly new to excel programming,
I am passing in a HTML file to Excel using Style guidelines.
<style
<!--table
@page
{mso-header-data:"&CMultiplication Table\000ADate\: &D\000APage &P";
mso-page-orientation:landscape;}
br
{mso-data-placement:same-cell; mso-word-wrap:true;}
--
</style
Does anyone know the syntax or even if it possible to globally set the
cells
so that the format is
FormatCells.Alignment.TextAlignment.vertical = top
FormatCells.Alignment.TextControl.wordwrap = true
set in the HTML style tags as above.
Thanks in advance
Andrew
|