+ Reply to Thread
Results 1 to 2 of 2

VBA Error Message for VPN Disconnect

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    71

    VBA Error Message for VPN Disconnect

    Hello!

    I have an Excel 2010 report containing VBA code that runs a proc and queries via Rocket Shuttle for Workstation, version 9.2.17. The report is run daily and some of those who run the report connect to the system via our corporate VPN.
    I need to create some error handling code that will re-set the report if the VPN disconnects.
    I appreciate any suggestions/help you guys can offer.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: VBA Error Message for VPN Disconnect

    Don't remember where I got this code from but I use this to test for a LAN connection, maybe it helps?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  2. An error message on open - a totally blank VBA message box
    By Mr_Tigas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2013, 11:29 AM
  3. [SOLVED] replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM
  4. Shared Workbook - how to disconnect the pop-up...
    By bondcrash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2006, 10:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1