Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
Excel-Html | Excel Discussion (Misc queries) | |||
Excel to Html | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) | |||
HTML in Excel VBA | Excel Programming |