Command button to get a Word document

Hi,

I am using Excel 2002 currently I have workbook that has 6 different types
of worksheet all of the worksheet consist of data input and formulas except
for 1 worksheet. The examiners are auditing our clients inventory. The one
worksheet (Client letter) that the examiners use is sort of predefined
letter where they typed up information The letter can vary from industires,
Manufacturing, Retail, etc. Basily we copy and paste the template from the
bottom of the Client's letter. The problem with that is Excel is not MS
Word. I am wondering what is the best way I tackle this problem? I have
about 5 different letter types and I would like to keep everything in Excel.
I believe I can add a Word control, but how do I add the various industries.
Do I need to have 5 different command buttons to open up Word?. Any tips or
help or website to go for an example will be appreciated. Thank you.

You could use a form with a radiobutton(with 5 elements) and a commandbutton
the user has to choose which lettertype he wants and click the button.

I would use a single combo box drop to select the industry along with a
single command button like "Create Letter" on a docked toolbar, if you know
how to do that.


"Alex Martinez" <[email protected]> wrote in message
news:%[email protected]...
>
> Hi,
>
> I am using Excel 2002 currently I have workbook that has 6 different types
> of worksheet all of the worksheet consist of data input and formulas
> except for 1 worksheet. The examiners are auditing our clients inventory.
> The one worksheet (Client letter) that the examiners use is sort of
> predefined letter where they typed up information The letter can vary
> from industires, Manufacturing, Retail, etc. Basily we copy and paste the
> template from the bottom of the Client's letter. The problem with that is
> Excel is not MS Word. I am wondering what is the best way I tackle this
> problem? I have about 5 different letter types and I would like to keep
> everything in Excel. I believe I can add a Word control, but how do I add
> the various industries. Do I need to have 5 different command buttons to
> open up Word?. Any tips or help or website to go for an example will be
> appreciated. Thank you.
>
>

We cannot understand your description of problem.
Please elaborate

--
Regards
PY & Associates

"Alex Martinez" <[email protected]> wrote in message
news:%[email protected]...
>
> Hi,
>
> I am using Excel 2002 currently I have workbook that has 6 different types
> of worksheet all of the worksheet consist of data input and formulas
except
> for 1 worksheet. The examiners are auditing our clients inventory. The
one
> worksheet (Client letter) that the examiners use is sort of predefined
> letter where they typed up information The letter can vary from
industires,
> Manufacturing, Retail, etc. Basily we copy and paste the template from
the
> bottom of the Client's letter. The problem with that is Excel is not MS
> Word. I am wondering what is the best way I tackle this problem? I have
> about 5 different letter types and I would like to keep everything in
Excel.
> I believe I can add a Word control, but how do I add the various
industries.
> Do I need to have 5 different command buttons to open up Word?. Any tips
or
> help or website to go for an example will be appreciated. Thank you.
>
>
>