topic Re: How to save excel file with current date using macro in QlikView

How to save excel file with current date using macro

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I have a sheet with 2 objects.

These objects are sent to an existing Excel document using macro. (Found on this community)

Then is saves the file (overwrite)

I need to save the file with a sort of timestamp in it's document name.

Who can help me?

I need to save the file like this:

' Save and quit

objExcelSheet.SaveAs "C:\documenten\test\test20140612.xlsx"

objExcelApp.Application.Quit

SET objExcelSheet = NOTHING

SET objExcelApp = NOTHING

But then with a variable date / date function.

Thanks,

Kevin

Thu, 12 Jun 2014 12:23:55 GMT

Thu, 12 Jun 2014 14:47:16 GMT

Thank you,

This was the right solution..

Now I have 1 more question:

I want Qlikview to open the saved file

This is an action on a button that calls the Macro and opens the file.

I need the same date in this screen at "bestandsnaam": (Sorry for the dutch system language)

Someone who knows how to solve this?

Thanks,

Kevin

Thu, 12 Jun 2014 15:34:55 GMT

place this expression in place of filename/bestandsnaam.

='D:\Test\Test'& year(today())&num(Month(Today()),00)&day(today())&'.xlsx'

='D:\Test\Test'& year(today())&Repeat('0', 2 - Len(num(Month(Today()))) )& num(Month(Today()))&day(today())&'.xlsx'

Fri, 13 Jun 2014 08:10:44 GMT

Thanks!

This works