Refreshing a report every X minutes while the file is still open


I have a request where a jet report needs to be presented on a display and gets refreshed every 5 minutes. So the file will always be open on that display, and the data needs to be refreshed every 5 minutes automatically without anyone doing anything.

Is this possible? I've read that you can use Excel VBA to get Jet to refresh a report but I'm not sure how that would work with the file always being open. I haven't had a chance to test the VBA route yet, wondering if anyone has done something similar

1 comment

Please sign in to leave a comment.