Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

microosoft word

Recently developed Visual Basic application to extract data from db2 and
place into Microsoft word document. Application runs fine.

Manager then changed specs from approximately 15 to 100+ users for this
application. Problem is that their network is not setup properly to blast
any changes down to all users. Hence if one small change is made to the
application you have 100+ manual rollouts to do. Not a good
scenario.

Would a thin client application help, where the user points to a server
side application and extracts data when needed? Problem here is that
Microsoft office is not geared for a server-side automation.

Are there any suggestions that can be made here? Any and all comments
are appreciated.
[774 byte] By [bob] at [2007-11-9 17:48:10]
# 1 Re: microosoft word
There are several possible solutions, depending on what you want to do. For
example, you could set up the VB app on a server to run
periodically--perhaps once per hour or once per day. It would create the
Word document in a defined location, which you could then serve to users via
a link on an ASP page. That way, users would get reasonably up-to-date data
whenever they click the link. You can also read the file and stream the
contents back to the browser using the application/msword MIME type header.

If you need more timely data, another way is through Word automation: for
example, you could write a Web service that collected the data on the
server, and call the Web service from within Word, populating a document
template and displaying the results. You can use the MS Web services toolkit
to accomplish this.

Finally, Word can display HTML documents directly (in recent versions), so
if your Word versions support that capability, you could just write your ASP
page to format the data the way you want it and have the users simply open
that URL in Word, via a shortcut. Doing it this way would provide up-to-date
data, and eliminate the need for both the VB application or a Web service;
however you are limited to the formatting capabilies of HTML.

"bob" <mayday1970@hotmail.com> wrote in message
news:3e25cd94$1@tnews.web.dev-archive.com...
>
> Recently developed Visual Basic application to extract data from db2 and
> place into Microsoft word document. Application runs fine.
>
> Manager then changed specs from approximately 15 to 100+ users for this
> application. Problem is that their network is not setup properly to blast
> any changes down to all users. Hence if one small change is made to the
> application - you have 100+ manual rollouts to do. Not a good
> scenario.
>
> Would a thin client application help, where the user points to a server
> side application and extracts data when needed? Problem here is that
> Microsoft office is not geared for a server-side automation.
>
> Are there any suggestions that can be made here? Any and all comments
> are appreciated.
Russell Jones at 2007-11-11 23:17:38 >
# 2 Re: microosoft word
Bob,

Till recently, whenever I had such a requirement, I used to write components
in VB and access the same from ASP.

But recently I came across an open source project called Cocoon from Apache
which works like a charm. Using this, I can generate not only Word, but Excel,
PDF, etc etc. Cocoon is basically a Servlet that raises the usage of XML
and XSLT technologies for server applications. You can find more info about
this at http://xml.apache.org/cocoon/

HTH,
Harish Mohanbabu

"bob" <mayday1970@hotmail.com> wrote:
>
>Recently developed Visual Basic application to extract data from db2 and
>place into Microsoft word document. Application runs fine.
>
>Manager then changed specs from approximately 15 to 100+ users for this
>application. Problem is that their network is not setup properly to blast
>any changes down to all users. Hence if one small change is made to the
>application you have 100+ manual rollouts to do. Not a good
>scenario.
>
>Would a thin client application help, where the user points to a server
>side application and extracts data when needed? Problem here is that
>Microsoft office is not geared for a server-side automation.
>
>Are there any suggestions that can be made here? Any and all comments
>are appreciated.
Harish Mohanbabu at 2007-11-11 23:18:32 >