PublishObjects.Add in reverse order

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top