Hy all.
I need some help.
I will be very grateful and will pray-full for any help.
I don't know about using macros in excel.

I am using excel 2013. I have a workbook which has connections to SQL Server for power query and pivot tables.
I want that the data connections in work book may be refreshed at specific time intervals and workbook may be saved.
Can some one please guide me for adding and enabling macro for this purpose.
I am completely raw in adding macro. So please someone guide me completely with some example.


I will be very much grateful for this help.