Hi all,

I am hoping that someone can help me with the following.

I have already recorded a macro to refresh 2 separate queries within a workbook.

Sub Data_Refresh()
'
' Data_Refresh Macro
'

'
    Sheets("Datatab").Select
    Range("A2").Select
    Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
    Range("N2").Select
    Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
    Sheets("Summary").Select
    Range("B1").Select
End Sub
I now need to get this macro to refresh at 07:00 each morning (the file can remain open) as well as convert to a .pdf and email the tab named 'Summary' to 4 separate users once the refresh is complete. The amount of data is minimal, so the refresh is almost instant.

I know this is achievable, but am struggling a little.

Any help would be much appreciated.

Thanks in advance,

TM.