So here's what i am doing manually
I have a range defined for a chart. I save it as "single file web page" and publish the range as an ".mht" in my local.
Can i use a macro to do so.

Heres what i got when i tried to record a macro

Sub Macro1()
'
' Macro1 Macro
'

'
Application.Goto Reference:="Z"
With ActiveWorkbook.PublishObjects("2015-R2_DefectSource_Master_21468")
.Filename = _
"C:\Users\jatin\Documents\FixTimes.mht"
.Publish (False)
.AutoRepublish = False
End With
End Sub


Any help is appreciated.