Wingdings 2

HCL Domino Domino Forum
1

I am trying to create a checkmark in excel in an export using lotusscript. I know if I use the wingdings 2 font with a capital P it will display a checkmark. When I try it all I get is a capital P but no checkmark! The rest of the line after the checkmark needs to be a different font. Here is a snippet of the code. Has anyone else tried this? Thanks for your help.

If docWatch.InitiativeCreated(0) = “Yes” Then

			excelsheet.Cells(row, 3).Font.Name = "Wingdings 2"

			excelsheet.Cells(row, 3) =  "P"

			excelsheet.Cells(row, 3).Font.Bold = True

			excelsheet.Cells(row, 3).Font.size = 9

			excelsheet.Cells(row, 3).Interior.ColorIndex  = 10

			excelsheet.cells(row, 4) = docWatch.InitiativeName(0)  & " - "  & docWatch.title(0)

			excelsheet.cells(row, 4).Font.size = 9

			excelsheet.cells(row, 4).Font.Name = "Trebuchet MS"

			excelsheet.cells(row, 4).columnwidth = 44

			excelsheet.cells(row, 5) = "'" & docWatch.IndustryAvg(0)

			excelsheet.cells(row, 5).Font.size = 9

			excelsheet.cells(row, 5).Font.Name = "Trebuchet MS"

			excelsheet.cells(row, 5).columnwidth = DataColumWidth

			excelsheet.cells(row, 6) = "'"& docWatch.Target(0)

			excelsheet.cells(row, 6).Font.size = 9

			excelsheet.cells(row, 6).Font.Name = "Trebuchet MS"

			excelsheet.cells(row, 6).columnwidth = DataColumWidth

End If