1 Reply Latest reply: Feb 9, 2017 5:02 AM by varaha sasi vardhan kandragula 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




      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?