Morning,
I ran a few searches, but am not entirely sure what i should be asking for.
So i apologize if I missed the answer to my question.

I am attempting to develop an Excel worksheet that will ultimately pull the
data into a word doc using the Copy - Paste Special method.
What i am wondering is that in one section of the word doc is a Requirements
page. This page can have anywhere from 1 to 50 separate line items on it.
Each one is numbered, (1. 2. 3., etc)
Instead of just creating 50 numbered lines and using 50 cells in the excel
worksheet then going back after updating the information on the word doc and
deleting the blank numbers not used, can i either:

a) on the excel worksheet, prompt the user to enter how many numbers they
will require, then somehow write a macro to pull the information over into
the word doc. (i am not sure how i would do this without presetting the Copy -
Paste Special)

b) write a word macro to auto erase the unused numbers after updating

Now option 'b' sounds like it would be easier to code, but i am not sure
where to begin with that.

Thank you in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1