A
AlfredAmoo
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
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