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

Did you mean to post this in a Word group. This group is for Excel
programming questions.

--
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

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

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

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

The first idea I had was to put the data inside a sheet. One line for every
paragraph. Since the standard report is what we expect, the user should not
be able to hide any standard paragraph or unhide any unstandard paragraph. As
example, the report contains 50 paragraphs and depending of the financial
position (calculate in an other sheet used for report table), only 30
paragraphs are standard. So, the user works with only 30 lines that cannot be
hidden.

In column2, I could add an option « Dont display it ». In column 3, I
could give choice to add the text at the end of the paragraph. Column4, Add
text inside a new paragraph (just after the standard one), Column5, Add text
in a new paragraph (after the paragraph in column4). The column1 could be a
concatenate of the standard text and column3,4,5. Any added text should be in
green color. Any hidden text should be in red. Maybe it is the simpler way to
proceed. (will required Events programming to adjust the row height, text
color, put new text, hide unstandard column) At the top of the sheet, I could
put a Command Button to "Refresh the report". I don't really like the idea
that column3,4,5,6, will be to write text. Is there a better way to do that?

I don't need rich text formatting, wordwrap or indenting since the report
will be formated in word (can adjust text if want bullet or ...). Also, I'll
adjust the text with the paragraph format of the word document.
Thanks!!
--
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

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