Also, If I use concatenate to put text together, I cannot have differents
color.. So, the Events programming should put text together without using a
function.
--
Alex St-Pierre


"Tom Ogilvy" wrote:

Unless you were going to just work with paragraph or section titles, it seems
like that would be cumbersom for the user in a tree view - but maybe not.

I think in Excel, I would us the group and outline feature under the data
menu and then the user could easily hide or unhide sections, add text and so
forth and when done, go right to printing. However if the text to be added
requires rich text formatting, wordwrap, indenting and so forth, then I don't
know if Excel is that useful. Only you can say.

--

"Alex St-Pierre" wrote:

Thanks Tom,
I'm agree that 80% of the work is in word. I posted in Excel Programming
since I thought that the tool should be in excel. To manage the report
paragraph, I could print the report inside an Excel sheet (instead of Word)
(one line per paragraph and wraptext) and thereafter, I could add text at
specific place inside the sheet (column #2,3, .. or add line) Maybe, using
VBA and a Treeview could show a preview of the report. With the treeview, I
could add the possibilty to click/unclick some sections or paragraphs. I
could also add a macro that all the user to add text or insert new paragraph.
All I need is to stock the informations added inside a sheet. This is
probably the best solution but maybe very complicated. I don't know if
someone have already done a project like that?
--
Alex St-Pierre


"Tom Ogilvy" wrote:

Ah, I see you actually used the word Excel in the subject. Best to make the
body of the post complete and stand alone. In any event, it sounds like 80%
of the work is in getting your paragraphs from word, which would be more
appropriate for a word group.

for information on automating word from another office application:


http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

--
Regards,
Tom Ogilvy


"Alex St-Pierre" wrote:

Hi,
I have a Word report to produce from excel. I would like to add a tool to
help manage which paragraph should be displayed in the report. So, the user
could see all standard paragraph and see if he wants to add it or not. So, he
could decide to 1) display standard paragraph or not 2) add text after a
specific standard paragraph (inside same par.) 3) add text into a new
paragraph. Im wondering what is the best way to do that?
Thank you!
--
Alex St-Pierre