Trouble exporting chart to htm file - need help

[Jacson]

*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 Autpen()
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"), _
"Autpen"
End Sub

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

 

[Cory Lantman]

I received that error before using the same type of code.
Check to make sure that the path you're writing the .htm
file to exists. If it doesn't, Excel won't create it and
it will just error out.

 

[Roy]

this works in my application using Excel XP...

With ActiveWorkbook.PublishObjects.Add
(xlSourceChart, "\\servername\foldername\chart.htm", "Chart
2" _
, "", xlHtmlChart, "gathery_31521", sheader)
.publish (True)
.AutoRepublish = False
End With

 

[Hank Freeman]

Give a an e-mail. I will help you on this

(e-mail address removed)