Export a table from Qlik to Excel starting to the first empty row

[#1]

Hi guys,

I'm a new user and I have some little problem with the qlikview macro.

I have to export the data of a pivot tab in qlikview always in the same file excel starting from the first empty row

Could you help me ?

Thanks in advance

[bindu_apte]

Hi,

Are you trying to achieve exporting pivot table into same excel file but in different sheets? or

In the same sheet?

[adamdavi3s]

Hi,

It is a long while since I did this but if Qlikview won't run the necessary code then what you can do is just add the macro in excel and tell qlikview to call this when you open it.

The actual VBA code is obviously very simple, assuming you can use column A to detect if the row is blank or not

Range("A" & Rows.Count).End(xlUp).Offset(1).Select

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

[#4]

Hi,

thanks for the help. I'll try this function; I think could be what I need

Regards