VBA to refresh data & email

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.

Please Login or Register  to view this content.

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.

Hi again all,

Can anyone help me on this at all?

I am desperate to get this spreadsheet functioning correctly.

Many thanks,