topic filter with macro before export to excel in QlikView

filter with macro before export to excel

Fri, 20 Jun 2014 09:22:13 GMT

Hello everyone,

thank you very much for the support so far here. You are great.

I have so far managed using a macro to export a table. However, these data should be filtered before export it, best also via Macro. Does anyone know of a way? The approaches presented here have not yet brought me to the destination.

Thank you for your help.

Kind regards,

Chris

My previous macro:

Sub exportToExcel

set obj = ActiveDocument.GetSheetObject("CH695_903948695")

obj.ExportEx "E:\SASCHA_Export\test.xls", 5

msgbox("Export successfully completed.")

end sub

Re: filter with macro before export to excel

Gysbert_Wassenaar — Fri, 20 Jun 2014 09:27:53 GMT

Use a Select in Field action to make the selection and add that action to the same object you added the Run Macro action. Make sure the Select in Field action is placed above the Run Macro action so that the selection is made before the macro is executed.

Re: filter with macro before export to excel

Fri, 20 Jun 2014 09:53:15 GMT

Yes u're right. I already tried this. But unfortunately it doesn't work.

See here my code:

Sub exportToExcel

ActiveDocument.Fields("# GPartner").Select "=2"

set obj = ActiveDocument.GetSheetObject("CH695_903948695")

obj.ExportEx "E:\SASCHA_Export\test.xls", 5

msgbox("Export successfully completed.")

end sub

I got following errormessage => Object required: 'ActiveDocument.Fields(...)'

"# GPartner" is the description from the exporting table.

Kind regards,

Chris

Re: filter with macro before export to excel

omyahamburg — Fri, 20 Jun 2014 10:53:54 GMT

You need to delete the equal sign:

ActiveDocument.Fields("# GPartner").Select "2"

Re: filter with macro before export to excel

Fri, 20 Jun 2014 12:08:45 GMT

Nothing happens except the error already described.

Also tried another column without the "#" and another value.