Autosave by timer

Hello,
can someone give me a solution,

i have an excel file and i want a VBA code for autuosave by timer and in specific location.

so when i open the excel file the code should run automatically and count 30 second then save it in specific location.


Thanks in advance.

.

Please Login or Register  to view this content.

Dear Logit, thank you for your help, the code working as well, but is there an option to run the code without clicking on the button ? like the code start automatically when i open the file.

YasserKhalil, can you please edit it in the file that Logit send it, im not good in the coding so i dont have an indea where to write your code.