Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Now, save that xml as a html in my web_page directory...
Message
 
 
To
11/10/2005 09:49:18
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056887
Message ID:
01057940
Views:
29
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)
*                  StandardLbl= "StandardLabel"+ALLTRIM(STR(iArrayElement))

                  .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") && .Publish(.T.)
               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.
Previous
Reply
Map
View

Click here to load this message in the networking platform