I created the following macro in MS VS in order to publish an excel chart
periodically;

Sub Auto_Open()
ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"C:\Book3.htm" _
, "Chart1", "", xlHtmlStatic, "Book3_11572", _
"Chart Title").Publish (True)
Application.OnTime Now + TimeValue("00:01:00"), _
"Auto_Open"
End Sub.

I get the following error -' runtime error 1004 - Application Defined or
Object Defined error'. Can anyone see what is wrong with the above macro?