none
Publisher 2007 vba help RRS feed

  • Question

  • I’m using Publisher 2007, with the following VBA code:

     

        Set pubShape = ActiveDocument.Pages(1).Shapes.AddTextbox(pbTextOrientationHorizontal, 10, 80, 400, 200)

        pubShape.TextFrame.TextRange.Text = "The current dollar amount is "

        pubShape.TextFrame.TextRange.InsertMailMergeField 10

       

    The code works but the merged field is a number that I would like to get formatted as currency.

    How can I format InsertMailMergeField 10 as currency so that I get $1,675.21  instead of 1675.21  ?

     

    Any suggestions will be greatly appreciated.

    Tuesday, August 16, 2011 2:00 PM

Answers

  • Issue resolved by changing the number to text in the source.

    Thanks for the help.

    • Marked as answer by DriveEV Wednesday, August 17, 2011 8:44 PM
    Wednesday, August 17, 2011 8:44 PM