View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Microsoft Word Object

Hi, Steve. Not sure what you mean by:
there is a lot of text in the Word Documents. so to clean things up, I
copied the text from Word as a Word Object.

Whenever I've had a project like this, I have a Word document that is called
up by my Excel code and values are inserted into the document, which is then
SavedAs a new document.

is it possible to insert some of
the values from my program into the actual word object? Most of the
values
the program generates will be passed into cells in the quote sheet.

It's very possible to pass values from an Excel worksheet into a Word
document. Your terminology of a "Word object", though, is getting in the
way of understanding your situation. In VBA coding, a "Word object" is a
coded object reference to the Word application object

but in
some cases, i want to insert one of the calculated values into a paragraph
of
the Word Object.

This is also very easily done in a Word document. All you need is some kind
of reference point in the doc - it could be a bookmark, a field, the seventh
word of the third paragraph - and the right code.

Ed

"steve" wrote in message
...
I have a wizard that creates quotes. Before we had this wizard, the person
quoting the job would have to figure out pricing by hand, then type the
values into a Quote Template in Microsoft Word. I have converted the
Quote
Word Documents into seperate worksheets in my wizard. Depending on the
user
input, the program will select the appropriate quote.

there is a lot of text in the Word Documents. so to clean things up, I
copied the text from Word as a Word Object. is it possible to insert some
of
the values from my program into the actual word object? Most of the
values
the program generates will be passed into cells in the quote sheet. but
in
some cases, i want to insert one of the calculated values into a paragraph
of
the Word Object.

My guess is that this will be difficult. any suggestions?

Thanks,
Steve