Use a meaningful file name for excel export

[#1]

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

[#2 · Accepted solution]

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.

[#3]

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

[#4]

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

[#5]

how can we achieve the same in "qlik sense "

[ashishbp]

Hi Prasanth,

Have u got solution?

[hykal1993]

Hi,

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