Export using different font

[Anonymous]

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?

[vardhancse]

Hi,

Can go through below URL for reference

How to change the font style and font size in macro?