How can I make a "SaveAs" or a "Export as" macro?

When I look at the methods supported by Zoho VBA, it appears "SaveAs" and "Save" method, but when I try to create a macro writing the code, it doesn't work. It says that is not supported.

I'm trying to make a sheet for my company which data changes all the time and need to save a copy in pdf format several times a day.

I know I can do it manually, but due the nature of the work is necessary to do that task just clicking a button in the spreadsheet.

I have others issues to solve, but I'll do it in some others posts.

Thank you.