*Bump*
I receive a run time error 1004 within the macro below.
The message says, "Application-defined or object-defined
error".
Being a real novice, I don't know what to look for. So any
help would be appreciated.

Using Excel 2000, my worksheet periodically imports
selected data from an Oracle 9i database. On the same
worksheet the data is charted. I want the chart to be
periodically dumped to a .htm file so users opening
the .htm file see the updated chart data.

workbook is sample_db_query_to_html.xls
worksheet is AvgMin_by_Loc
chart title is Average Minutes by Location
output htm path is \\Shared\Office\Temp\AvgMinLoc.htm

Here's the macro:
Sub Auto_Open()
ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"\\Shared\Office\Temp\AvgMinLoc.htm", _
"AvgMin_by_Loc", "", xlHtmlStatic, _
"sample_db_query_to_html.xls_16365", _
"Average Minutes by Location").Publish (True)
Application.OnTime Now + TimeValue("00:05:00"), _
"Auto_Open"
End Sub

Any ideas what might cause the error would be accepted.
Thanks.
..