I have a Microsoft Word document I use as a template for entering an
order when I receive it from a client. For simplicity's sake, this is
a .DOC file, not a .DOT file. There are various Text Form Fields
throughout the page, and the form is protected so that I can quickly
tab from field to field, filling in the information as necessary.
I realize this method for entering orders is clunky, since I have an
Apache server with PHP and MySQL on my server and I could easily
create a Web page to gather the information, store it, and spit it
back to me in an HTML-formatted page. The problem with this solution
is that I end up emailing the MS Word document to another co-worker
who does his job off-site. Basically, I create the stub file for him,
and he fills in the rest of the information on his end when he does
his job. We do not have a VPN, so accessing the Web site to enter
information on his end is not an option.
I would like to get the order information into the database when I
receive the order without going through the extra step of manually
filling out the MS Word file as well. I know PHP is capable of
accessing COM Objects to interact with applications, so I?m assuming
there?s some way to tell the Word document, through PHP, to fill in
certain form fields with the data I entered into the database through
my Web form.
My question is what process I might use to access my MS Word file
through PHP to have it automatically fill in the Text Form Fields
based on values I submit through my Web form. Also, I realize Adobe
probably offers products like this, but that would involve paying more
for commercial products. Even still, if using a particular product
from Adobe?s family is a possibility, and if it is compatible with an
Apache/PHP setup, I?d be interested in hearing about that as well. |