How to align Html table on left side

[shiva_raj]

HI,



When I Run the automail code i get the output like below (excel table align in Center) . Suggest me How to align "HTML Excel table " to the Left side.


image.jpg



regards
shiva

[Richard Buttrey]

I've not studied the code in detail yet but where is the cursor when the macro is run?

[Andy Pope]

As you are using the publishobject I think you need to change the alignment of the used range first

Please Login or Register  to view this content.

[shiva_raj]

HI Andy,


Thank you for reply. I want to align entire table "to the left".

[shiva_raj]

HI Richard, thank you for reply. Code is running properly. But in the final output (as in image) excel table comes in the middle. I want to align that entire excel table to the "Left side" only. help me.

[Andy Pope]

In that case you will need to add some HTML around the sText variable in order to left align content.

& "< html > < body >< div align=""left"" >" & stext & "< /div >< /body >< /html >" _
& vbNewLine & vbNewLine _