topic Export data using macro in QlikView

Export data using macro

Mon, 25 Jul 2011 18:08:05 GMT

I am exporting the data in a straight chart to .xls in a specified path. works fine BUT I want to name the .xls file with today's date. Is there a way I can pass date stamp for the file name?

sub export

set obj = ActiveDocument.GetSheetObject("CH191")
obj.ExportBiff "\\shared-us\Archive\shared\DAILY_EXPORT\Today().xls"

END SUB

Export data using macro

danielrozental — Mon, 25 Jul 2011 18:25:40 GMT

Sure, try something like

sub export

set obj = ActiveDocument.GetSheetObject("CH191")

obj.ExportBiff "\\shared-us\Archive\shared\DAILY_EXPORT\" & year(date())*10000+month(date())*100 + day(date()) & ".xls"

END SUB

Export data using macro

Mon, 25 Jul 2011 18:49:25 GMT

Thanks Dan

But I want my file named as mm-dd-yyyy-daily.xls .

Export data using macro

danielrozental — Mon, 25 Jul 2011 19:05:11 GMT

There is plenty of vbscript resources in the web, I would recommend this one as a reference http://w3schools.com/vbscript/vbscript_ref_functions.asp

sub export

set obj = ActiveDocument.GetSheetObject("CH191")

obj.ExportBiff "\\shared-us\Archive\shared\DAILY_EXPORT\" & right("0" & month(date()),2) & "-" & right("0"&day(date()),2) & "-" & year(date()) & "-daily.xls"

END SUB

Export data using macro

Mon, 25 Jul 2011 19:14:43 GMT

Thanks for the refernce and solution .. That really helps