Macro export to Excel (without specify the path)

[Black_Hole]

Hello all,

I would like to run a macro in Qlikview which will allow me to display my table in Excel and without specify the path. 

Please could you tell me if it's possible to do that in QVW.

Thank you in advance for your help.

[jaibau1993 · Accepted solution]

Hi!

You don't need a macro, you can right click any object and then click on "Send to Excel".

If, evenso, you need to write a macro, then use this code:

set obj = ActiveDocument.GetSheetObject(ObjID)
obj.SendToExcel

Regards,

Jaime. 

[Black_Hole]

Hi @jaibau1993 !

Tested and approved the macro.

Many thanks for your quick reply 👍