To pass on or not to pass on

J

Jason Logue

Hi. I am trying to make an important decision regarding a client, and
I hope the collective wisdom of this newsgroup can help me out a
little bit. I have been working with this client who wanted an easy
way in Word to enter information in form documents. I used the
userform macro to create a series of userforms that enabled them to
enter their data, click OK and voila, their forms are finished. I
recently showed them this and they were very pleased; however, there
is one request they had initially I was unable to fulfill. They
wanted a way to retrieve bookmarked sections of text (numbering above
200) in a seperate document from the current template without having
to open the other document. I worked on creating a combo-box on the
userform that would allow them to choose the bookmark from the manual,
but because I am still fairly inexperienced with VBA in Word, I was
unable to complete this feature by the deadline. Since they were
pretty pleased with the template thus far, they would like me to
continue the work, but they definitely want a way to retrieve the
information from this manual in a much easier fashion.

The last suggestion I received was that my method of storing the data
(bookmarked sections) may not work for this objective. Since I will
have more time now, I thought of either storing each section of text
in a txt file or doc file. Then I would need to find a way to have
them select 1-300 text or doc files from a combo-box or menu or
something like that on the userform.

My question is: should I consider passing this on to a developer who
would probably create some sort of module or is it possible for this
to be done in Word? More importantly, is it possible for this to be
done in Word by a newbie VBA developer? I realize part of this will
be a judgement call on my part, but if any of you could suggest a
direction to head in with this macro, that would be great. This group
and the other Microsofto Communities have been an invaluable source of
information.

Let me know if I need to clarify anything. Thanks for your
assistance.

-Jason
 
S

sjane

The feature Insert, File and selecting Range permits inserting bookmarked
text in a document by entering the name of the bookmark. I haven't seen
your form, but I believe you should be able to work that into your code.

Sjane
 
R

Rick Stebbins

Hi Jason,

Since it sounds like the text they want to store is
content for a manual, I recommend storing it in a document
(or several) and naming each chunk of text with bookmarks.
This allows them to store formatted content and to edit it
themselves in a familiar environment -- as long as they
are careful not to delete or rename the bookmarks.

Here is code to retrieve the content:

Selection.InsertFile YourFile, YourBookmark, False, False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top