Topics

1

Finished Programs / FINISHED: Reopen file after Wifi reconnects

« on: November 14, 2017, 09:07 PM »

Hi, first post here.
My situation is a bit complex so please bear with me, any suggestions to help flesh out what I need are appreciated.

I have an always-on computer "dashboard" that displays a log through Excel. There is a "Source" Excel file located on a network drive, and a "Dashboard" Excel file located locally on this computer. The Dashboard file has a data connection/query to the Source file, set to refresh every minute. So if someone adds something to the Source file, it gets updated on the Dashboard in near-realtime.

Here's the problem: The dashboard computer is connected to the network via Wifi, and for whatever reason it sometimes disconnects for a short time. When this happens and the Excel file tries to refresh, it pops up with this error box, because the source file is not available. Even if the Wifi reconnects, Excel apparently "pauses" and will not refresh until I dismiss the error box:



Here's two possible ways I thought of that perhaps can workaround this issue:

• A program that detects when the Source file is no longer available, and once it becomes available again, closes and reopens the local Dashboard file
• A standalone Excel query/file viewer program that will not grind to halt if the Source file is unavailable, but will just silently and patiently wait for the file to become available again

Thanks in advance for any suggestions!