Solved

Setting range to 'bold' fails (MS Word automation, vb.net)

Posted on 2003-11-16
5
987 Views
Last Modified: 2012-08-14
I'm writing a document generator with vb.net and Word automation. I've found some info on the net,  and I can succesfully modify bookmark values to create a fresh document, like so:

Dim oWordDoc As Word.Document = oWordApp.Documents.Open(fileName, missing, oReadOnly, missing, missing, missing, missing, missing, missing, missing, missing, isVisible)

Dim oBookmark As Object = myBookmarkName

oWordDoc.Bookmarks.Item(oBookmark).Range.Text = myText

However, it doesn't work when I try to change the formatting of this bookmark, to bold, italic or underlined, like so:

oWordDoc.Bookmarks.Item(oBookmark).Range.Font.Bold = True

I've tried replacing 'True' with '1', but it doesn't add any formatting changes to the open word document.

I've also tried grabbing the range first, but that doesn't work either:

Dim oRng As Word.Range = oWordDoc.Bookmarks.Item(oBookmark).Range
oRng.Font.Bold = True

The range object also has Bold, Italic, and Underline properties, but I haven't had any succes with those either. Oh, and I've tried setting the text value before and after the formatting change, but that doesn't seem to be the problem either.
0
Comment
Question by:Rapido
  • 3
  • 2
5 Comments
 

Author Comment

by:Rapido
ID: 9760492
I found the answer! This is how it should be done, with a selection:

Dim oRng As Word.Range
                Dim oSel As Word.Selection

                oRng = oWordDoc.Bookmarks.Item(oBookmark).Range
                oSel = oWordApp.Selection()
                oSel.Start = oRng.Start
                oSel.End = oRng.End

                If (drDocVar("IsBold") = True) Then
                    oSel.Font.Bold = True
                End If

                If (drDocVar("IsItalic") = True) Then
                    oSel.Font.Italic = True
                End If

                If (drDocVar("IsUnderlined") = True) Then
                    oSel.Font.Underline = True
                End If

                oSel.TypeText(myText)
0
 
LVL 7

Accepted Solution

by:
wsteegmans earned 500 total points
ID: 9760525
Try something like this:

Dim oWordDoc As Word.Document = oWordApp.Documents.Open(fileName, missing, oReadOnly, missing, missing, missing, missing, missing, missing, missing, missing, isVisible)

oWordApp.Selection.GoTo (wdGoToBookmark, missing, missing, oBookmark.Name)
oWordApp.Selection.Font.Bold = True
oWordApp.Selection.TypeText (myText)

You can also create a Style with these characteristics:
- Style Type: Character
- Font: Bold

Before typing your stuff, you choose this Style, like this:

oWordApp.Selection.Style = oWordApp.ActiveDocument.Styles("StyleBold")
oWordApp.Selection.TypeText (myText)
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9760528
You found it already yourselves ... :-)
0
 

Author Comment

by:Rapido
ID: 9760653
Thanks anyhow. I'd be happy to give you the points so this question gets archived, I haven't been able to find an answer anywhere else....
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9762398
Thanks! But your solution is the most beautiful way!

Some additional info about Office Programming in VS .Net. With the new Office (2003), you can now also write managed code in your .Net programs to control Word or Excel ... Visual Studio .NET can help you incorporate Microsoft Office Word 2003 and Microsoft Office Excel 2003 into your custom solutions by providing tools and classes to make automation easier. You can also use Visual Studio .NET as your development environment for other Office applications.

Read more:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrconmanagedcodeofficeobjectmodels.asp
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question