How to unlock power of XML in Office 2003?

[KK Ong]

We have large amounts of old Word docs created (related to our company products) with pretty standard sub headings inside.

How do I use the power of XML conversion or anything that Office 2003 can offer to store data from the docs into like "Excel" columns of information so that another user can use some interface to
1. See and choose from all the variable areas of work possible for each "column" of information (am thinking in Excel mindset) e.g. under "products" column, there are forecasting systems, sales systems, operations systems and under "cost" column there are low, medium, high and very high etc (something like auto filter capability).
2. Select combination of variables across columns.
3. And later print out a report adhering to my particular selection containing data that is written under the particular variables chosen e.g. a selection with Forecasting systems and high cost would have some writeup about the particular forecasting system in it automatically and the pre sales guys saves time and just have to vet the draft that was auto created from his selection .
4. And it should be accessible to only allowed personnel who do quotes for the company.

Regards,
KK

 

[Bob Buckland ?:-\)]

Hi K.K.,

You may want to visit the MS Office XML newsgroup
news://msnews.microsoft.com/microsoft.public.office.xml

You may also want to visit
http://msdn.microsoft.com/office/
http://officezealot.com
and
http://msdn.microsoft.com/office/understanding/xmloffice/default.aspx


======
We have large amounts of old Word docs created (related to our company products) with pretty standard sub headings inside.

How do I use the power of XML conversion or anything that Office 2003 can offer to store data from the docs into like "Excel"
columns of information so that another user can use some interface to
1. See and choose from all the variable areas of work possible for each "column" of information (am thinking in Excel mindset) e.g.
under "products" column, there are forecasting systems, sales systems, operations systems and under "cost" column there are low,
medium, high and very high etc (something like auto filter capability).
2. Select combination of variables across columns.
3. And later print out a report adhering to my particular selection containing data that is written under the particular variables
chosen e.g. a selection with Forecasting systems and high cost would have some writeup about the particular forecasting system in it
automatically and the pre sales guys saves time and just have to vet the draft that was auto created from his selection .
4. And it should be accessible to only allowed personnel who do quotes for the company.

Regards,
KK >>
--
I hope this helps you,

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

Office 2003 explained
http://microsoft.com/uk/office/editions.asp