Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble exporting chart to htm file - need help
*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. .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble exporting chart to htm file - need help
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. -----Original Message----- *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. .. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble exporting chart to htm file - need help
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 -----Original Message----- *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. .. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble exporting chart to htm file - need help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble Exporting Word Questionaire into Excel | Excel Worksheet Functions | |||
Exporting txt file | Excel Discussion (Misc queries) | |||
Exporting to CSV file | Excel Discussion (Misc queries) | |||
exporting chart | Excel Discussion (Misc queries) | |||
Exporting CSV file to unicode .txt file - " around strings | Excel Discussion (Misc queries) |