S
Shorty
I created the following macro in MS VS in order to publish an excel chart
periodically;
Sub Aut
pen()
ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"C:\Book3.htm" _
, "Chart1", "", xlHtmlStatic, "Book3_11572", _
"Chart Title").Publish (True)
Application.OnTime Now + TimeValue("00:01:00"), _
"Autpen"
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?
periodically;
Sub Aut
pen()ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"C:\Book3.htm" _
, "Chart1", "", xlHtmlStatic, "Book3_11572", _
"Chart Title").Publish (True)
Application.OnTime Now + TimeValue("00:01:00"), _
"Aut
pen"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?