can I rename a spreadsheet with VBA in zoho sheet?

I know that I can rename the spreadsheet (ie the whole file) by clicking on the title in the GUi and renaming it.

And I know when I am in the list of all spreadsheets, I can rename it using the menu, eg the context menu.

But I would like have a VBA macro attached to a button in a spreadsheet that renames that spreadsheet. For example, to put the current day, as calculated by Date(), in the name of the spreadsheet.

I don't even know if you can do this in Excel or in LibreOffice Calc because the file would be open as you ran the VBA macro code.

Thanks!