Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reverse name order from Last, First to First Last in Exc | Excel Discussion (Misc queries) | |||
Reverse Row Order? | New Users to Excel | |||
Reverse Order | Excel Discussion (Misc queries) | |||
reverse order | Excel Discussion (Misc queries) | |||
Reverse the order? | Excel Programming |