I have a large spreadsheet, that among other things, publishes several charts from a worksheet to a network drive. Runs fine
in Excel 2003 but fails in Excel 2007.
The error is:
Run-time error '1004'
Application-defined or object-defined error
The code where it fails is:
ActiveChart.ShowWindow = True
"P:ReportsOps ChartsFriday.htm", "ThisDay Chart", "Chart 81", xlHtmlStatic, _
"Stats worksheet 2006_22191", "").Publish (True)
ChDir "P:ReportsOps Charts"
ActiveWindow.Visible = False
Now, the original macro was created by recording a manual effort of publishing the chart and then this has been promulgated
into the code with lots of options.
I tried to re-create the macro again in excel2007 but it will not go past the 'Publish As Web Page' dialog box because it
does not recognise the chart as an object.
The error message for this is:
The chart Chart 81 no longer exists on sheet ThisDay Chart. This item will be
deleted from the list of previously published items in this workbook
While troubleshoorting, I noticed that in xl2003, on the graph, I can right click and one of the options is 'Chart Window'.
This is not present in xl2007.
Any suggestions would be welcomed....