topic Re: Use a meaningful file name for excel export in QlikView

Use a meaningful file name for excel export

Fri, 09 Apr 2010 17:58:17 GMT

Maybe I'm dreaming, but it never hurts to ask, eh?

When I send an object to Excel, it comes up with that system generated file name based onthe object name, date, and time. What I'd like to be able to do is set a file name based on the bookmark selection.

If not that, how about can the name be set some other way? I'm thinking maybe a variable that I can manipulate via a macro.

Am I asking for too much?

Thanks,
Dino

Use a meaningful file name for excel export

Fri, 09 Apr 2010 18:02:57 GMT

This should do it for you, to do this you will have to have your own "export to excel" button for the object instead of using the default one.

Use a meaningful file name for excel export

Mon, 12 Apr 2010 07:41:52 GMT

Hi,

Like this way also we can achive..

Sub Test
set obj = ActiveDocument.GetSheetObject("TB07")
File = "C:\"&"MM 0"& DatePart("M", Now()) & DatePart("D", Now()) & DatePart("YYYY", Now()) & ".csv"
obj.Export File, ","
End sub

Regards,

K Ravi Kumar

Use a meaningful file name for excel export

Mon, 12 Apr 2010 13:52:30 GMT

Thanks to both of you for the ideas. May be a while, but will try them out when I get a chance.

Re: Use a meaningful file name for excel export

Tue, 03 Oct 2017 10:51:56 GMT

how can we achieve the same in "qlik sense "

Re: Use a meaningful file name for excel export

ashishbp — Fri, 06 Oct 2017 09:02:32 GMT

Hi Prasanth,

Have u got solution?

Re: Use a meaningful file name for excel export

hykal1993 — Wed, 17 Oct 2018 06:17:35 GMT

Hi,

Is there a way I can export combination of multiple table in one workbook by changing the code?