ws.Range("B5").Value = "បរិយាយ" ' Description ws.Range("C5").Value = "សេវាកម្មប្រឹក្សា" ' Consulting service
' Read Khmer text from UTF-8 .txt file khmerText = ReadUTF8File("C:\khmer_text.txt")
' Export to PDF ws.Range("B2").ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=ThisWorkbook.Path & "\output.pdf", _ OpenAfterPublish:=True End Sub VBA UserForm controls (Label, TextBox) do not support complex scripts like Khmer reliably. Workaround: Use WebBrowser control or simply avoid forms – use Excel cells as input/output. vba code excel khmer pdf
If you must use a form:
' Export ws.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=ThisWorkbook.Path & "\Khmer_Report.pdf", _ Quality:=xlQualityStandard, _ OpenAfterPublish:=True End Sub | Issue | Solution | |-------|----------| | VBA editor corrupts Khmer | Store Khmer text in Excel cells or external UTF-8 files | | PDF shows boxes (tofu) | Set cell font to a Khmer font before export | | Sorting/filtering Khmer | Use Excel's built-in sorting (Unicode-aware) | | Message box shows "?" | Avoid MsgBox for Khmer – write to a cell or debug.print (immediate window may also fail) | | ADODB.Stream not available | Reference "Microsoft ActiveX Data Objects" in VBA (Tools → References) | 7. Complete Example: Automated Khmer Invoice PDF Sub CreateKhmerInvoicePDF() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Invoice") ' Populate Khmer data (assume values in cells) ws.Range("B2").Value = "ឈ្មោះអតិថិជន" ' Customer Name ws.Range("C2").Value = "សុខ ច័ន្ទ" ' Sok Chan _ Filename:=ThisWorkbook.Path & "\output.pdf"
' Export to PDF Dim pdfPath As String pdfPath = ThisWorkbook.Path & "\Invoice_" & Format(Now, "yyyymmdd_hhnnss") & ".pdf"
' Place into cell ws.Range("B2").Value = khmerText ws.Range("B2").Font.Name = "Khmer OS" _ Filename:=ThisWorkbook.Path & "\Khmer_Report.pdf"
' Define PDF output path pdfPath = ThisWorkbook.Path & "\Khmer_Report.pdf"