Re,
Blacksap on peut l'améliorer encore certainement mais voici un exemple
Sub Htm(Chemin As String, WS As String, plage As String)
ThisWorkbook.PublishObjects.Add(xlSourceRange, Chemin, WS, plage, xlHtmlStatic, "", "").Publish (True)
End Sub
Sub Test()
Dim plage As String, NomHtm As String
Const Rep1 = "C:\"
NomHtm = "Toto.htm"
plage = Sheets(1).UsedRange.Address ' à adapter
Debug.Print plage
Htm Rep1 & NomHtm, Sheets(1).Name, plage 'appel
End Sub
A+++