Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

how can we achieve the same in "qlik sense "

ashishbp
Contributor
Contributor

Hi Prasanth,

Have u got solution?

hykal1993
Contributor II
Contributor II

Hi,

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