Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save web pages as HTML in Excel 2003? | Excel Discussion (Misc queries) | |||
picture as link in Excel generated html | Excel Programming | |||
Controlling HTML and web pages through Excel? | Excel Programming | |||
Opening an HTML doc - inconsistent results manual vs macro. | Excel Programming | |||
Ftp an html file generated by an excel macro | Excel Programming |