Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
thanks a lot! its everything i need