thanks :~)
I've eliminated the attempt to build the screen so the code is now simular to ...
FOR itabor = 1 to .ActiveWorkBook.WorkSheets.Count
iDime= iDime+.ActiveWorkBook.WorkSheets.Count
DIMENSION aTheDMDxls(iDime)
iArrayElement= iArrayElement+ 1
aTheDMDxls(iArrayElement)= laFileListWS [ifw,1]+"\"+ALLTRIM(.ActiveWorkBook.ActiveSheet.Name)
.ActiveWorkBook.WorkSheets(m.iTabor).Activate
.range("A3").select()
.ActiveWorkBook.SaveAs("\\webserver\ChartDir\HTMLs\"+laFileListWS [ifw,1], xlHtml)
gLogMESS= " HTML sheet -- "+ .ActiveWorkBook.ActiveSheet.Name
DO WriteLog
.ActiveWorkbook.PublishObjects.Add(xlSourceChart,"\\webserver\ChartDir\HTMLs\"+laFileListWS [ifw,1], ;
.ActiveWorkBook.ActiveSheet.Name, .Parent.Name, ;
xlHtmlStatic, "", "Edgar Published From XL")
ENDFOR
ENDIF
EndWith
ENDFOR
>Edgar,
>I will try this code in home and let you know what happened.
>(If in this message below is whole your code)
>
>>Thank you Cetin and Borislav,
>>
>>I can see that Cetin's code is functional, but for my already derived charts the .Publish only errors out.
>>
>>I may need to reestablish my intensions; the publish may be expecting some completed portion web page that I have not developed yet.
>>
>>I have successfully automated a master-sheet update from SAP that feeds the linked Charts.
>>This is my first attempt at corporate web development, so, I am understandably confused...
>>
>>All that I need is to provide a final web page that will allow the end user to select from a 'button menu' business sector providing a list of the appropriate 'completed' charts for that department, where a buttons-for-xl-chart will open the created web-page of that chart.
>>I have not developed the big-button forms yet, I do have the excel charts saving as xml. Presentation (touch-screen and web) is everything. Currently we have 52 total spreadsheet-charts - but it would be nice for the end user to be able to interact with charts to change display for specific time frames (would be a bonus). Chart 'Growth', number and variation, is inevitable.
>>
>>What I thought would be the easiest part of the life cycle - is turning out to be the most challenging.
>>
>>
Edgar L. Bolton, B.S. B.B.A.