Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?