export all worksheets as html

[Ronio]

I was able to use Ron DeBruin's excellent macro to take a master sheet and
break it into seperate sheets based on a value in the first column.

Now I need a macro that will save every worksheet to HTML with the 'add
interactivity' box checked.

Can somebody point me to an existing macro?

TIA,
Ron

 

[Jacob Skaria]

Try

=Format(range("start_Date"),"dd-mm-yyyy")

If this post helps click Yes

 

[Jacob Skaria]

Sorry the below is a wrong post

 

[Ronio]

Nevermind, some days I'm just not thinking clearly.

I embedded the "ActiveWorkbook.PublishObjects" inside of DeBruin's original
macro.
So it saves the worksheet as html after populating it.