Recently the question was asked How do I open a Word document from a Base macro? The solution given works wonderfully but how should the code be altered so that the text will appear in a scroll textbox on the form?
To be specific: I’m trying to get the text contained in a writer document into a text box of a database. The idea is to use the text box as a ‘Help’ guide, giving an inexperienced user of the database information about what the various buttons etc on the form that he/she is presently looking at, do. The text for each particular form would be held in a separate writer document and its contents would be displayed by the macro when the relevant form is opened. The previous solution mentioned above displays the whole document in a separate window rather than having it displayed on the form itself and is therefore inconvenient as a ‘Help’ text. But the advantage of having the text on a writer file rather than embedded in the macro lies in the convenience with which the text could be modified and maintained.
I have written a macro that gets a text explicitly quoted within the macro into the box (hardly, I agree, a great feat!) and I know how to connect the macro with the open (Base) document event. What I still need to do is to capture the raw text from the writer document and insert it into my Base macro which then puts it into the text box. I think the problem is that I have no idea about writer macro commands. My hope is that someone well-conversed with macros for writer can help me. My present project is developing a rather complex database and I would appreciate any help on, at least for me at the moment, the ‘fringe’ topic of writer macros!
Bottom Line: I am hoping that someone on the forum can share with me the couple of lines of script that illustrate how to grab the text from the document. With that clue I hope that I can write the the rest of the code.
If you can help I would be most grateful.