Refresh all queries on workbook open, when finished print to pdf then close workbook

I have data that daily needs to be refreshed and printed to pdf.

I figure the simplest way to do this would be to task schedule the workbook to open daily.
Then on open it will refresh the data, print it after all data has been refreshed and close the workbook.

I set it up originally without the need to print so I have all the queries set to refresh when opening the file, however when I now try and put the code to print to pdf on the workbook open event it runs before the queries are finished running.
(Query notes:
queries were created through Microsoft query, and are accessing a MySQL database
queries set to refresh when opening the file
queries set to enable background refresh).

I am very new to scripting so if anybody could provide simple step by step instructions on how I could do this it would be greatly appreciated

Can't see the code so I'm guessing....

Maybe setting a delay can do the trick?

Please Login or Register  to view this content.

Thanks Gerard, but that just seemed to pause the whole app.
It hung on the splash screen for 3 minutes (that is the time I input) and then printed to pdf, and is now refreshing the queries.

Think I have it solved.... (more testing this afternoon)
Went thru all queries and unticked Enable background refresh and refresh on open checkbox options.
Then in Open sub did a refresh all and then code for printing to pdf. Appears to have worked but still need to test further
Will update success/failure tomorrow.

During splash screen all macro's are on hold.
If you put the splash screen up for 3 minutes nothing will happen during 3 minutes...... I don't think that was your goal.

I think you should place the wait code after the query refresh code, before printing.
Refreshing takes a few seconds......