excel to html
 

Hi

I need to create an htmlfile from excel.
I know how to do that, but, when I want to print it, it´s too big for just
one page.

How to edit the file so that it fits on one page?
If I print it in excel it fits on one page.
I guess there has to be some code to change size before I create the
htmlfile.

This is the current code:
With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
ActiveWorkbook.Path & "\SendMail\" & sAnstnr
& "_" & g_sMailaMonth & ".htm", iblad.Name _
, sMonthRng2, xlHtmlStatic)
.Publish (True)
End With
bMailFilFinns = True

Anyone?

Thomas