PublishObjects.Add in reverse order
Help! In an attempt to save historical versions of a report, I use the code
below to save a worksheet at the end of the day to htm. The last saved instance is always appended at the bottom of the history file. Is there a way to have the last saved instance go to the top of the resulting htm file? Thanks! -Alfred ActiveWorkbook.PublishObjects.Add( _ SourceType:=xlSourceRange, _ Filename:="c:\temp\dashboard_history.htm", _ Sheet:="Dashboard", _ Source:="A1:M106", _ HtmlType:=xlHtmlStatic).Publish |
All times are GMT +1. The time now is 03:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com