Excel Chart - HTML/Publish

[IanC74]

Hi

I have created a chart in excel from progress and i need to save this as a html.

Ive added the publish objects line:

vchWorkBookublishObjects:ADD(xlSourceChart,"C:\web1.htm","Sheet1","Chart1",xlHtmlStatic,"xx","").

Yet this does not create the c:\web1.htm file.

I see from doing a macro of the same process in excel there would be another line Publish(true):

With ActiveWorkbook.PublishObjects.Add(xlSourceChart, "C:\webtest-sop.htm", _
"Sheet1", "Chart 2", xlHtmlStatic, "webtest-sop_3957", "")
.Publish (True)
End With

But does anyone know how I code for this?

Help

 

[plus_marca]

Hi.

I think you can try something like this:

def var chPublishObjects as handle.


chPublishObjects = vchWorkBookublishObjects:ADD(xlSourceChart,"C:\web1.htm","Sheet1","Chart1",xlHtmlStatic,"xx","").

chPublishObjects:Publish = True.

or

chPublishObjectsublish.