Macro to export report to excel preserving the report format and with relative filepath

[Anonymous]

Hi there,

  I'm using this macro to export my report to excel, however it not really excel but csv then being opened via excel.

  Is there a way to twik this macro to export the report in real excel format? This way, all the report aesthetics and formating will be preserved when it's converted to excel.

Sub ExportExcel

set v = ActiveDocument.Variables("vXLS")

v.SetContent "1",true

ActiveDocument.getsheetobject("InternEvalXLSExport").Export "d:\InternshipEvaluation.csv",","

v.SetContent "0",true

End Sub

Also, is there a way to make the file path relative?

currently, we are using relative path in all our qlikview files.

ex:

vFolder_PG_CS ='..\QV_Source_Data\PG\OnTRAC\'

I'd like to save and open the converted excel file in the relative filepath above assigned to the variable vFolder_PG_CS .

Is this possible?

Many thanks.

[beck_bakytbek · Accepted solution]

Hi Ronald

check this: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

maybe you find another solution for your case

i hope that helps

Beck

[Anonymous]

thanks a lot! its everything i need