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