Thanks for the pointer and link, Kurt -- I'll take a look into that.

On May 25, 5:28 pm, "Kurt" wrote:
Actually, scripting a VPN connection is quite easy and, although not
directly related to Excel, you could launch a simple script from Excel that
would start a VPN. I'd suggest Windows built-in VPN client for your database
clients, using PPTP - mainly because it's so easy to set up. Then you can
script a connect/disconnect using "rasdial". Launch it from excel using the
"shell" command. Rasdial can connect or disconnect a VPN (or other) session.
Here's a link to rasdial info.

http://www.microsoft.com/resources/d...s/xp/all/prodd...

I think this would be a fairly easy to implement solution for automating
secure connections. You have to create the VPN connections first (from the
add network connection wizard).

...kurt