VBA Excel automatic email daily cell value

Hi guys, I am fairly new to vba.

I need a macro to automatically email a range of cell values everyday at 9am. The cell values are pulling live data from a website.

I have looked everywhere can can't find the script for it. Help is appreciated.

Welcome to the forum! I guess it depends. There are several parts to this task.

Will the workbook be open all the time? Application.OnTime would then be used.

You could set it to open in Windows Task Scheduler, do its thing, and then close. A WScript popup MsgBox would be added to allow time to abort the automacro should it ever need to be edited.

No I wish to never open the file, I just want to receive updates to a cell value. The cells are refreshing every hour from the website.

I just need these values sent to emails