Dear All,
I have a task that exports a range to an HTML page. In Excel the range is auto sized to fit standard paper for printing. When I open the HTML page in the browser and print, it covers 2 pages (just a bit too wide).
Is there any way to modify the HTML page to fit better? or add coding to the export to fit it better?
My export code:
ActiveWorkbook.PublishObjects.Add(xlSourceRange, filename, "Linage Report", "$B$39:$I$118", xlHtmlStatic, title, ""
.Publish (True)
Thanks in advance for any help.
Mike (m6)
I have a task that exports a range to an HTML page. In Excel the range is auto sized to fit standard paper for printing. When I open the HTML page in the browser and print, it covers 2 pages (just a bit too wide).
Is there any way to modify the HTML page to fit better? or add coding to the export to fit it better?
My export code:
ActiveWorkbook.PublishObjects.Add(xlSourceRange, filename, "Linage Report", "$B$39:$I$118", xlHtmlStatic, title, ""
.Publish (True)Thanks in advance for any help.
Mike (m6)