2 Replies Latest reply: Feb 10, 2017 4:05 AM by Paul Wonford RSS

    Header align

    Paul Wonford

      Hi guys,


      I'm exporting to excel using this 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 put in the chart or in the template the header center aligns and i want it to left align. I've tried all sorts of things but i'm stuck - can anyone suggest anything?