Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formatting Cells Using VB code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formatting Cells Using VB code
Thanks tim,
Good start and cool having the correct syntax, does anyone know if this routine can be run from the <head section to format the cells, have tried playing, adding to the HEAD tag and after the body tag to no avail ? can anyone help? Andrew "Tim Coddington" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I color code comments in cells on Excel spreadsheet? | Excel Worksheet Functions | |||
Formatting Code for SI Units in Excel | Excel Worksheet Functions | |||
Excel formatting-cells | Excel Programming | |||
Excel 2002 - VBA code to insert copied cells?? | Excel Programming | |||
Formatting a cell in Excel, using pure VB code | Excel Programming |