B
battle.chris
Hello.
I've grabbed the following code from a tutorial on DevX (http://
www.devx.com/webdev/Article/10172) to periodically publish chart data
to a live webpage.
Sub Aut
pen()
ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"X:\charts\ResponseDist.htm" _
, "Chart1", "", xlHtmlStatic, "DevXSample_16365", _
"").Publish (True)
Application.OnTime Now + TimeValue("00:05:00"), _
"Autpen"
End Sub
The macro works fine the first time I run it from the VB Editor, but
fails on subsequent time with "The macro 'C:\Documents and Settings
\Chris\My Documents\ChartUpdate2.xls'!Autpen' cannot be found."
I've tried locating the code in the Chart, Sheet and Workbook modules
without luck.
Can anyone see where I'm going wrong?
I've grabbed the following code from a tutorial on DevX (http://
www.devx.com/webdev/Article/10172) to periodically publish chart data
to a live webpage.
Sub Aut
pen()ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"X:\charts\ResponseDist.htm" _
, "Chart1", "", xlHtmlStatic, "DevXSample_16365", _
"").Publish (True)
Application.OnTime Now + TimeValue("00:05:00"), _
"Aut
pen"End Sub
The macro works fine the first time I run it from the VB Editor, but
fails on subsequent time with "The macro 'C:\Documents and Settings
\Chris\My Documents\ChartUpdate2.xls'!Aut
pen' cannot be found."I've tried locating the code in the Chart, Sheet and Workbook modules
without luck.
Can anyone see where I'm going wrong?