ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inconsistent appearance of HTML pages generated by Excel VBA (https://www.excelbanter.com/excel-programming/367345-inconsistent-appearance-html-pages-generated-excel-vba.html)

[email protected]

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.



All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com