AlmostVinDiesel
New Member
- Joined
- Oct 26, 2005
- Messages
- 18
I've built an Excel VBA Application using QueryTables that connects to an internal server. Users must be logged in through VPN to connect.
Sometimes, however, even if a user is logged into VPN, excel sometimes doesn't realize it. I know this is the case bc if I hit the same URI in a web browser, data is returned just fine. Instead, excel hangs and has to be force-quit.
Does anyone have suggestions on how to mediate this?
Properties within the query table? Executing something in the command-line?
Sometimes, however, even if a user is logged into VPN, excel sometimes doesn't realize it. I know this is the case bc if I hit the same URI in a web browser, data is returned just fine. Instead, excel hangs and has to be force-quit.
Does anyone have suggestions on how to mediate this?
Properties within the query table? Executing something in the command-line?