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 much Appreciated.
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 much Appreciated.