Results 1 to 11 of 11
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Large Amount of Text (Excel 97 and >)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    I am soliciting some ideas about how to, or what, is the best way to capture and store large amounts of text using MS-Excel.

    OK here is what I am trying to do.

    I want to capture a lot of text , say a story of 2000+ words, or say about 10,000 characters, into a textbox on a form, and then store it some place. The ultimate goal is to produce a report using MS-Word, from data coming from MS-Excel.

    Kinda emulate the memo field in MS-Access.

    Then I want to store this text into a MS-Word document, and search of key words mark them say make them bold, and then send them back to MS-Excel as categories into a DropDown.

    Any ideas would be paid for with Parker Brother's Monopoly Money <img src=/S/money.gif border=0 alt=money width=17 height=15>, lots of it... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large Amount of Text (Excel 97 and >)

    But if you want to store the text in Word, why not let the user enter it in Word? Excel is not exactly the ideal application for text entry. I can't imagine users enjoying entering 10,000 characters in a text box.

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Large Amount of Text (Excel 97 and >)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hans

    What you are double teaming me now, The Windows 2000 forum, and here <img src=/S/grin.gif border=0 alt=grin width=15 height=15>, well its a wonderful thing to have this lounge.

    Yes I am considering this, maybe open Word as the text editor for Excel, but I need some help with that. I mean I know how to open Word from Excel, but what do I do when I need to find a specific document, and them go to a specific place, say line number 17 or the beginning of paragraph 9, in that document. Also the return trip, I need some sort of an array that can work in both applications.

    Am I making sense here?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large Amount of Text (Excel 97 and >)

    It sounds like you need to take a closer look at the Word Object Model. There are ways you can go to Paragraph 9 (or whatever) using the Word Object Model.

    Your overall plan is rather vague. It almost sounds as if you're trying to create a Word Master Document using Excel. (Anything would be better than using a Word Master Document. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) Can you give us a bit more of a 3-D picture of what you are actually trying to do?
    Gre

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large Amount of Text (Excel 97 and >)

    Hi Wassim,

    I don't know what your goal is, but if you want to produce something that contains large amounts of formatted text, I would think that Word is the better tool for it. You can include Excel tables and charts in a Word document. On the other hand, if you need the end result to be in Excel, you can include Word document objects in your worksheets. And if really necessary, you can use hyperlinks to jump to a bookmark in a Word document from Excel, and to a specific cell or range in Excel from Word.

  6. #6
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large Amount of Text (Excel 97 and >)

    Hi Wassim

    But why?

    No, it's not intended to be an unhelpful response.. Assuming you have created this application, how would it be used? Who are the users, how would they access the data? It is sometimes helpful to understand the final intended use so that the optimum solution can be constructed.

    Regards
    Peter

  7. #7
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Large Amount of Text (Excel 97 and >)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> unkamunka

    Sure I'll try and give you a more detailed picture of what I have been asked to do.

    We are implementing a complaint database with a front end made with MS-Excel. This was the initial design thinking, but now, with budgets the way they are, some <img src=/S/dragon.gif border=0 alt=dragon width=17 height=15> person decided that we can't have a real database, and we will use what we have, which is Excel and Word. MIS dept did not load even Access on these PCs that will be used.

    I can enter the names, addresses, and dates and details of the complaint and Excel will do a great job at that, but when I get to the narrative of the complaint, things become dicy and I have no real database. Limitations are beyond my control, I have been arguing about this since March 2003, so its dead set now.

    So the complaint database, which I am responsible for implementing the Front-End in Excel has no real back end and I am forced to use Word.

    I don't see this as a total waste of time and effort, since the report will be a Word document, also to be designed and implemented by me, later, I thought that from the get go I can help Excel's data entry and Word's data entry to be synchronized. By synchronized I mean that when I open Excel to look at case number 1234 I need to get the narrative of case 1234 from Word so I need to have, maybe a table of Contents, a way to grab it.

    I hope this makes things clearer, and that I am not over shooting the moon, but this is why I posted this inquery.

    Thanks a Million... in Monopoly money by the way...

    Wassim



    Maybe I am wrong, maybe some one has a better idea, but is that not the purpose of this message?
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  8. #8
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Large Amount of Text (Excel 97 and >)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Peter

    Please check the thread, I have added some posts responses to clear up why I am doing what I am doing.

    Its a complaint database without any real back end database product. So I need to capture details about the complaint, name, address, date of birth, and the liks and Excel will handle that perfectly, but also I need to capture some narrative about what the complaint is all about, and that can be a huge blob of text.

    So, not having the real tools to work with, I need to wing it with using Word to store the text portion, and analyze it, and Excel will store all other data.

    Thanks

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large Amount of Text (Excel 97 and >)

    It looks like HansV's suggestion of embedding Word documents - representing your complaints - into Excel worksheets may well be the way to go. Naturally, I don't have any idea of how many complaints you get per day/week/month/year - and to what extent you are tied in to having the same workbook open for a distinct period. I would suggest that you may wish to have a new workbook for every 10 or even 50 (say) complaints - otherwise the files may start getting very large. On that basis, you would probably need a "master" log - which would have an abbreviated summary of Date Opened, Date Closed etc. HTH
    Gre

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Large Amount of Text (Excel 97 and >)

    an alternative to Hans' suggestion of embedding documents is to hyperlink the documents. Handle all the large text in fields DIRECTLY in word with a hyperlink in excel to the word document.

    You couls also include hyperlinks in the Word Docs to the "excel database"

    Steve

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large Amount of Text (Excel 97 and >)

    But surely you know, that one does not need Access installed at the clients to do a thing like this and use Access anyhow?

    It can all be done from Excel if one uses ADO to get and update the data from/to an Access file (so only the developer and the Administrator(s) need Access).

    I've set up a document control system in Word, using ADO to maintain a small database with document summaries in Access format. None of my users have Access installed.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •