OLE (LS) Currency value to Bookmark in Word doc

HCL Domino Domino Forum
1

I am using OLE to create a Word document and take information out of a Notes document and put into the Word document. The Word document is created using a template that has form fields already created with bookmark names. I am filling in the fields using:

WordApp.ActiveDocument.Bookmarks("Unit").Select

WordApp.Selection.TypeText( doc.Unit(0) )

However, to enter non-text data, I have to convert using Cstr() which causes me to loose formating expecially on my currency fields and numeric fields.

Any ideas would be greatly appreciated.

Thanks,

Courtney

2

Subject: OLE (LS) Currency value to Bookmark in Word doc

There is no such thing as currency in a Notes document. You can set a Number field in a form to display its value as currency, but the value stored in the document is just a number with no formatting information. Perhaps you can use the Format function, etc. to format the values the way you want them.

3

Subject: RE: OLE (LS) Currency value to Bookmark in Word doc

Yeah, I know about the number/currency issue, I was just trying to show what kind of formatting I was going for.

The FORMAT$ function works the way I wanted.

Thanks for the direction.