Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Use a meaningful file name for excel export

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

Use a meaningful file name for excel export

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.

View solution in original post

6 Replies
Highlighted
Not applicable

Use a meaningful file name for excel export

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.

View solution in original post

Highlighted
Not applicable

Use a meaningful file name for excel export

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

Highlighted
Not applicable

Use a meaningful file name for excel export

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

Highlighted
Not applicable

Re: Use a meaningful file name for excel export

how can we achieve the same in "qlik sense "

Highlighted
Contributor
Contributor

Re: Use a meaningful file name for excel export

Hi Prasanth,

Have u got solution?

Highlighted
Contributor
Contributor

Re: Use a meaningful file name for excel export

Hi,

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