Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The macro ... cannot be found
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 Auto_Open() ActiveWorkbook.PublishObjects.Add(xlSourceChart, _ "X:\charts\ResponseDist.htm" _ , "Chart1", "", xlHtmlStatic, "DevXSample_16365", _ "").Publish (True) Application.OnTime Now + TimeValue("00:05:00"), _ "Auto_Open" 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'!Auto_Open' 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro cannot be found, but it is there? | Excel Discussion (Misc queries) | |||
Macro cannot be found | Excel Discussion (Misc queries) | |||
Macro cannot be found | Excel Programming | |||
macro not found | Excel Programming | |||
Found a macro, but don't know how to use it | Excel Programming |