Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |