Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write current day in file export Macro

Hello I write this macro

function exportexcel()

set obj= ActiveDocument.GetSheetObject("CH32")

obj.ExportEx "C:\ProgramData\QlikTech\Documents\filename.xls", 5

end function

What i want to do is write the filename with current date, something like YYYYMMDD_filename.xls. Any idea for it?


Thank you in Advance,

Alfonso

0 Replies