Please can someone help publish my Excel chart to an HTML file using a
macro. I found the code:

With ActiveWorkbook.PublishObjects.Add(SourceType:=xlSo urceChart,
_
Filename:="C:\Work.htm", Sheet:="Chart1", Source:="Chart 1",
_
HtmlType:=xlHtmlStatic, DivID:="Chart1_04")
.Publish (True)
End With

But it does not work, I receive the error "Compile error: Expected
Function or variable".

Can anyone help?

Thanks,

Brett