Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Are you trying to achieve exporting pivot table into same excel file but in different sheets? or
In the same sheet?
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.
Hi,
thanks for the help. I'll try this function; I think could be what I need
Regards