ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Missing Text Boxes in XL2003 Html Publish (https://www.excelbanter.com/excel-programming/358606-missing-text-boxes-xl2003-html-publish.html)

CochranRB

Missing Text Boxes in XL2003 Html Publish
 
I used code

Sub AddHTMLCharts()
Dim chtobj As ChartObject
Dim strChartName As String
Dim vaDate As Variant
vaDate = Format(Date - 1, "yyyy-mm-dd")
Application.DisplayAlerts = False
Worksheets("Charts").Activate
For Each chtobj In ActiveSheet.ChartObjects
strChartName = chtobj.Name
ActiveSheet.ChartObjects(strChartName).Activate
ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
"\\edc-netstor1a\data$\System Performance Plots\DailyFiles\" _
& vaDate & "CBP" & strChartName & ".htm", _
"Charts", strChartName, xlHtmlStatic, strChartName, "").Publish
(True)
Next chtobj
Application.DisplayAlerts = True

to publish multiple charts in worksheet Charts in XL2000. Each chart
contains text boxes modified daily. When I upgraded to XL2003, the
text boxes no longer consistently display in the htm file. Suggestions?



All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com