VBA in Excel to Export HTML's

[staffie007]

Hey all,

I have 700 rows of data, grouped in groups of about 20 each.

Im wanting to export the groups into seperate web pages all using one template.
I have it exporting the information and saving the document using

        With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _
            "C:\Documents and Settings\Jason\My Documents\My Web Sites\NOC\Human Resources\NOC Human Resources - " & Office(1).Cluster & ".htm" _
            , ActiveSheet.Name, "", xlHtmlStatic, _
            "NOC Human Resources - " & Office(1).Cluster, "")

The problem is that Im wanting it on a black background and using this command causes the center to be black (where the cells are) and then the rest of the page to be white.

Is there anyway I can publish them using a black background?
Even if I have to use a different save command as its saving all of the pages onto my my docs and not uploading them.

Thanks!