Exporting an xls file with a predefined name

[Anonymous]

hi all,

i would like to export a table to an excel file,

with the name of the table + today's date,

do you know how to do this?

thanks,

Nir

[Anonymous]

try this....

public function Export

  set obj = ActiveDocument.GetSheetObject("EXPORT")

  ActiveDocument.GetApplication.WaitForIdle

  fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".xlsx"

  ActiveDocument.GetApplication.WaitForIdle

  obj.Export vFolder & fileName

end function

[#3]

Hi, Nir, Good resources here.

give default name to excel-export | Qlik Community

[Anonymous]

still the same gibrish..

the oly thing i changed is the EXPORT to the object ID in the report

obj.Export vFolder & fileName // what is vFolder? should i create it?

[Anonymous]

it's a variable defining the path to export to

here's an example that uses a slightly different approach...same principle though

[Anonymous]

Thanks for your help!

I think i understand it now,

the thing is i need to implement this for users that QV by access point,

while this works only on desktop client

[Anonymous]

Okay - then, yes, there are a couple of constraints.

Most (probably safe to say all) macro scripts will not execute within the AJAX client.

If you need to utilize a macro from access point for users then you could use the IE Plugin with IE as your browser....or you could have them open the qvw from the server using the qlikview desktop client.