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.
Bookmarks