topic Re: Macro export to Excel (without specify the path) in QlikView

Macro export to Excel (without specify the path)

Black_Hole — Sat, 16 Nov 2024 02:04:58 GMT

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 — Wed, 30 Oct 2019 15:50:40 GMT

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 — Wed, 30 Oct 2019 15:53:33 GMT

Tested and approved the macro.

Many thanks for your quick reply 👍