Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.winapi
Yo Yo is offline
external usenet poster
 
Posts: 11
Default Identify: VPN or Network - What API Function do I use?

How do you identify if a user is Local or VPN?
It will either be a VPN from a remote location or a Network Login from
inside the office.
Thanks in advance,
Yo.


  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.winapi
external usenet poster
 
Posts: 1
Default Identify: VPN or Network - What API Function do I use?

"Yo" wrote in message ...
How do you identify if a user is Local or VPN?
It will either be a VPN from a remote location or a Network Login from
inside the office.


I don't know that you can. The very nature of a VPN is to make it so that the remote user is effectively inside the
network - they are assigned a local IP.

What does it matter to your VB app?

-Pete


  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.winapi
Yo Yo is offline
external usenet poster
 
Posts: 11
Default Identify: VPN or Network - What API Function do I use?

My company has 2 offices which are a block appart. The main office needs to
know who in the secondary office is in (Local) or logged from home (VPN).
The secondary office is on a point to point T1 so it has the same internal
IP, and the VPN I am going to assume is different. Thanks for the
suggestions, Pete, Jake & Rob.

I am going to need to ID the machines IP address. Thanks
Yo.


"Peter Young" wrote in message
...
"Yo" wrote in message

...
How do you identify if a user is Local or VPN?
It will either be a VPN from a remote location or a Network Login from
inside the office.


I don't know that you can. The very nature of a VPN is to make it so that

the remote user is effectively inside the
network - they are assigned a local IP.

What does it matter to your VB app?

-Pete




  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.winapi
external usenet poster
 
Posts: 860
Default Identify: VPN or Network - What API Function do I use?

Hi Yo,

The only way I can think of to do something like this is look at the user's
IP address. If your Active Directory setup assigns designated IP addresses
to VPN users, then you can test to see if the IP is in that range.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Yo wrote:
How do you identify if a user is Local or VPN?
It will either be a VPN from a remote location or a Network Login from
inside the office.
Thanks in advance,
Yo.


  #5   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.winapi
external usenet poster
 
Posts: 1,236
Default Identify: VPN or Network - What API Function do I use?

Yo,

A lot of implementations use a set range of IP Addresses for VPN usage. You
could check for that.

Otherwise, a crude hack might be to measure ping times against a local
server.

Rob


"Yo" wrote in message
...
How do you identify if a user is Local or VPN?
It will either be a VPN from a remote location or a Network Login from
inside the office.
Thanks in advance,
Yo.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identify the network path a file was opened from (Excel2007) DataBoy Excel Discussion (Misc queries) 2 September 25th 09 03:33 PM
What does the 'Map Network Drive' function do? cravingmad Excel Worksheet Functions 1 October 24th 08 03:17 PM
Function to Identify the Modification of a Worksheet Penny Excel Worksheet Functions 1 June 26th 07 10:23 PM
Use Go to function to identify dependent cells between worksheets Yiannos Excel Worksheet Functions 2 May 24th 07 05:31 PM
Rnd function used in VB on network Tom Olmsted Excel Programming 0 January 21st 04 06:00 PM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"