Loading bookmarked text from a word doc to vba

[Grieg]

Hi,

I have a word template where I want the code behind it to import a section of bookmarked text from another word document and load it into a string\form property.

I can't use the open the document as a text stream as its a word doc - could anyone point me in the right direction.

Any help greatly appreciated,

Grieg

 

[SkipVought]

Hi,

You need to have both documents open.

Then some code like this...

Private Sub UserForm_Click()
    Set doc1 = Documents("doc1.doc")
    Set doc2 = Documents("doc2.doc")
    
    UserForm1.TextBox1.Text = doc2.Bookmarks("bm1").Range.Text
End Sub
Hope this helps  :-)

Skip,
Skip@TheOfficeExperts.com
[URL unfurl="true"]www.TheOfficeExperts.com[/URL]

 

[Grieg]

Hiya skip,

Problem was that I didn't want to open an active version of the document I was taking the text from so the user would only have the one visible document. In the end I solved it using the following code (included it in case any one ever has the same query!);

Dim objST As Object, strDocPath As String
strDocPath = x:\xxxxx\xxxxx.doc
Set objST = CreateObject(Class:="Word.Document&quot
Set objST = GetObject((strDocPath), "word.document&quot
'set controltipttext to first 150 chars of bookmarked text
Form.Label.ControlTipText = Left((objST.Bookmarks(pubStrKrBm1).Range), 150)

Thanks for your reply,
Grieg.

 

[SkipVought]

Well then you have to state that in your question! Can't read you mind.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Grieg]

You're right. Sorry for not making this clearer.

Grieg.