Quickpick Problem

[manager1]

Hi Gary,

I have downloaded your refresh quickpick example.
It sets the trigger on opening the workbook, but you have to reopen the workbook to set the trigger the next day from testing I've done.

I'm going away on holidays and would like to leave it all running and refresh each day at a certain time without reopening the workbook.

Is this possible?

[GaryRussell]

Do you mean this example http://gruss-software.co.uk/forum/viewtopic.php?t=3558

It works without you having to re-open the workbook so not sure why you are having a problem.

Have you tried putting debug statements in the VBA code to see if the code is running when it is supposed to be?

[manager1]

Thanks Gary, I'm not sure how to put debug statements in the code, but I'll let it run for a few days and see how it goes.
Thanks for your help.