Publish embedded chart XL2007
 

hello,

In Excel2003 embedded charts can be referenced and published to web
pages with:

With xlApp.ActiveWorkbook.PublishObjects.Add(xlSourceCh art, _
Where,
sht, "Chart 1", _

xlHtmlStatic, "", "")
.Publish (False)
.AutoRepublish = True
End With

Strangely, Excel2007 seems not to recognize embedded charts for
publishing and returns an error

Please help

Thanks
Avi