1 Reply Latest reply: Feb 9, 2017 5:02 AM by Sasi Vardhan KV RSS

    Export using different font

    Paul Wonford

      Hi guys,

       

      When i'm exporting to excel using the following code

       

      set XLApp = CreateObject("Excel.Application")

      XLApp.DisplayAlerts = False

      XLApp.Visible = true

      set XLDOC = XLApp.Workbooks.Open ("C:\Blank template.xlsx")

       

       

      ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard true

      XLDOC.Sheets(1).Range("a8").Select

      XLDoc.Sheets(1).Paste()

       

      Despite what i have set in my chart and what is set on the template it always exports using arial - can anyone tell me how to change this?