Discussion board where members can get started with QlikView.
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.
set v = ActiveDocument.Variables("vXLS")
Also, is there a way to make the file path relative?
currently, we are using relative path in all our qlikview files.
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?
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
View solution in original post
thanks a lot! its everything i need