G
Guest
Hi
I want to be able to create a dynamically updated table/chart in Word (and
Powerpoint). The client application will be word (or PP or Excel), and the
server will be a customised apache web server feeding either html or xml over
http.
I can already do render a table in Excel using html over http by using the
Excel VBA QueryTables object with the url of the remote data source as
follows:
With ActiveSheet.QueryTables.Add(Connection:= "URL;http://myurl",_
Destination:=Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
However this method is not available in Word (or PP). I have been reviewing
MSDN, and there are possibly two ways that I can see to do this.
1. Use ADO to connect to the remote server (via the url) and the
parse/format the html/xml data stream into a table or chart.
2. Develop an XML web service on the apache server to format a Word/PP XML
stream of data. Then use a SOAP client enbedded within word/PP to parse and
render the table/chart.
Option 1 and 2 seem are both intensive approaches, i.e. require a lot of
coding and will not be easy to setup.
Does anyone have any other suggesstions, or can you suggest how I can
implement option 1 or 2 in an efficient way?
Thanks in advance
I can be reached either here or directly at markmcgillion _at_ hotmail _dot_
com
I want to be able to create a dynamically updated table/chart in Word (and
Powerpoint). The client application will be word (or PP or Excel), and the
server will be a customised apache web server feeding either html or xml over
http.
I can already do render a table in Excel using html over http by using the
Excel VBA QueryTables object with the url of the remote data source as
follows:
With ActiveSheet.QueryTables.Add(Connection:= "URL;http://myurl",_
Destination:=Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
However this method is not available in Word (or PP). I have been reviewing
MSDN, and there are possibly two ways that I can see to do this.
1. Use ADO to connect to the remote server (via the url) and the
parse/format the html/xml data stream into a table or chart.
2. Develop an XML web service on the apache server to format a Word/PP XML
stream of data. Then use a SOAP client enbedded within word/PP to parse and
render the table/chart.
Option 1 and 2 seem are both intensive approaches, i.e. require a lot of
coding and will not be easy to setup.
Does anyone have any other suggesstions, or can you suggest how I can
implement option 1 or 2 in an efficient way?
Thanks in advance
I can be reached either here or directly at markmcgillion _at_ hotmail _dot_
com