Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inconsistent appearance of HTML pages generated by Excel VBA [email protected] Excel Programming 0 July 17th 06 01:49 AM
picture as link in Excel generated html Andy Dorph Excel Programming 0 May 12th 05 03:54 PM
Controlling HTML and web pages through Excel? guinness Excel Programming 0 February 22nd 05 08:03 PM
Opening an HTML doc - inconsistent results manual vs macro. KeithB Excel Programming 1 August 18th 04 06:38 PM
Ftp an html file generated by an excel macro -Jim Excel Programming 1 May 7th 04 09:47 PM


All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"