Inconsistent appearance of HTML pages generated by Excel VBA
I'm using the following code, adjusted slightly to accommodate
different sheet and file names, to save one sheet in each of two
workbooks as an HTLML file:
With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _
FolderName & HTMLFilename, "Sheet1", "", _
xlHtmlStatic, "External contact list_18114", "")
.Publish (True)
.AutoRepublish = False
In one HTML file resulting from the use of this code, the material
apppears as I want it, consistent with its appearance in the workbook:
All text is left-aligned on the left-hand side of the browser window.
In the other file, however, the text appears left-aligned, but in the
middle of the browser window. It's as if I have a left margin set
about for about 40% of the screen width.
Left margins are the same in both files, 0.75. All cells are
left-justified.
How can I get the text in the second file to move over to the left-hand
side of the screen? Other than that, the code does exactly what I want
it to.
|