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.

Command button to get a Word document
 

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.


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=397546

Command button to get a Word document
 

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" wrote in message
...

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.

Command button to get a Word document
 

We cannot understand your description of problem.
Please elaborate

--
Regards
PY & Associates

"Alex Martinez" wrote in message
...

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.