D
DFStoneJr
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.
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.