Hi,
I have a requirement where I need to provide the creation date of the excel in one of the cell, when it gets downloaded using the APEX office Print plugin in Oracle APEX.
I was trying the create a macro in the template by following below steps :
Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Clicked Insert >> Module, and pasted the following macro in the Module Window.
Function CreateDate() As Date
CreateDate = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Function
Step 3: Saved and closed this code, and returned to the worksheet.
Step 4: In a blank cell, entered the formula of =CreateDate(), and pressed Enter.
The created date gets inserted into the cell.
But now when I upload this template with macro in APEX, and then download a new report. It says that xlsm format is not supported. So I am not able to use a macro enabled template.
Is there any other way so that I can get the Creation date in one of the cell, when it gets downloaded from Excel?
Thanks