Manage Word paragraphs inside Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. I’m wondering what is the best way to do that?
Thank you!
 
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
 
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?
 
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.

--
 
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 « Don’t 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!!
 
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.
 
Back
Top