I want to get the HTML version of a sheet's range.

I recorded a macro :

Sub Macro1
With ActiveWorkbook.PublishObjects("marke****ch_30324")
.HtmlType = xlHtmlStatic
.Publish (False)
End With
End Sub

While recording, everything wors fine.
When I run the macro, it says: (from french):
"The method "Publish" of object "Publishobject" failed.

How come?

TIA,
--
AP