Publish embedded chart XL2007

A

avi

hello,

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

With xlApp.ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro errors when upgrading to windows 7 0
How to paste chart format in vba excel2010 0
Missing Chart Text Boxes in XL2003 Html Publish 0
Publish an Excel 2003 Chart to HTML file 0
Missing Text Boxes in XL2003 Html Publish 0
The macro ... cannot be found 0
Refresh a local web page via Excel 3
Publish active sheet as static web page 2

Top