Additional Empty space created with the values while exporting to excel using macro

[#1]

i Am trying to export excel from qlikview using macro, When the excel created there are some empty spaces created with the excel values, When i directly give send to excel from the chart there is not empty spaces with the values

Eg:

Date field will be like "Date "   So i need to remove the space from the excel

Please help me as soon as possible

[m_woolf]

You might post your macro code and a sample of the exported Excel.

[el_aprendiz111]

Hi,

Look this works fine.

sub Rpt_excelll
SET CHART = ActiveDocument.GetSheetObject("CH27")
SET X = Chart.GetProperties
Chart.SendToExcel
SET CHART=NOTHING
SET X = NOTHING
end sub