Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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.

1 Solution

Accepted Solutions
Highlighted
Master
Master

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

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

View solution in original post

2 Replies
Highlighted
Master
Master

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

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

View solution in original post

Highlighted
Creator
Creator

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

thanks a lot! its everything i need