vpn

Whether we're talking about ADO or DAO, the best use case for me has been querying data sets, some of which are Excel files. As long as the data source exists on the same network, the speed of ADO over an ACE connection far outperforms a WORKBOOK.open approach. I've noticed however that when...

Hi all - just wanted to some insight on running Excel over a VPN vs a virtual machine. We have a series of robust workbooks that use a lot of VBA several COM add-ins. Lately, we have been encountering a lot of workbook crashes for remote users(they happen at arbitrary times - can be while...

Hello, I have a vlookup that will return values such as the following: 1. "123.123.123.xxx" 2. "123.32.32.89 (VPN)" 3. "123.32.32.89 RT" 4. "123.32.32.89 VPN" 5. "D 123.32.32.xxx S 123.32.123.xxx" I currently have the following formula which only works in the first instance...

Hi, I'd like to know if there's a simple code for getting the vpn and ip address of a computer. Thanks. I already have the code for the username - I'm missing getting vpn and ip address or where the computer connects to the internet.

hi all !! and thanks for reading this. My problem is that I have a VPN in my office, in there we have several excel's files, 2 or 3 files are related for the Price column. but when I open one of this files it's updates de price value to another old, and the other file does too. and thats not...

My code has been working for a full year on XP, MSIE8, Cisco AnyConnect (VPN). We recently migrated to Win7 and did not have trouble to begin with, but after a couple months it now never works on the VPN. It is giving me this error: "The Object Invoked has disconnected from its clients"...

Hi. I was working with a friend this morning who just got hooked up to her office through VPN. She also just started using Excel 2013. We had a couple of problems as follows: 1. Every time we tried to paste something, we got a message that Excel couldn't paste. To get around it, we used...