How do I build a modular database?

[Guest]

I'm looking to build a specification guide within Word. I already have
specifications for products within a Word Document put together but it is
110+ pages long. It is too long to read through to highlight the products I
need specifications for and paste to a new Word Document. What I would like
to do is have a table of contents page that lists all of the products and is
some how tied to the specifications document I already have created. I would
like to have the ability to click on the products I need specs for from the
table of contents page and then after selecting those products it will
automatically create a new Word document with only the selected specification
on that page. Is there any way to do this....if this make sense at all?

 

[Robert M. Franz (RMF)]

Hi CWG

I'm looking to build a specification guide within Word. I already have
specifications for products within a Word Document put together but it is
110+ pages long. It is too long to read through to highlight the products I
need specifications for and paste to a new Word Document. What I would like
to do is have a table of contents page that lists all of the products and is
some how tied to the specifications document I already have created. I would
like to have the ability to click on the products I need specs for from the
table of contents page and then after selecting those products it will
automatically create a new Word document with only the selected specification
on that page. Is there any way to do this....if this make sense at all?

your final guides will probably have to be in PDF, not DOC? Then I can
see a solution.

By use of hidden text, you can hide whatever you don't need for a
certain document and print the rest into a PDF.

You don't want to mark anything manually as hidden, so you want to use a
dose of VBA to present, say, a Userform. This lets you check/uncheck
whatever parts you want, and the code afterwards does the marking.

Remaining question is: what are the smallest parts? You might mark the
document manually with bookmarks, list these in the Userform, and the
code applies hidden formatting to the bookmarks. Or you say the parts
are equal to headings, then the Userform lists these.

You want to get hold of a VBA programmer with more experience then
myself, for sure! Best try it in one of the dedicated .vba
forums/newsgroups.

..2cents
Robert