Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Macro export to Excel (without specify the path)

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.

 

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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

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. 

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

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. 

View solution in original post

Highlighted
Creator II
Creator II

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

Hi @jaibau1993 !

Tested and approved the macro.

Many thanks for your quick reply 👍