topic Re: Macro to export report to excel preserving the report format and with relative filepath in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

beck_bakytbek — Wed, 21 Jun 2017 10:49:15 GMT

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

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

Anonymous — Thu, 22 Jun 2017 02:42:47 GMT

thanks a lot! its everything i need