Maybe the wrong question, but here's the situation. I someimes develop VBA code and run Excel reports from home; i.e. remotely. The programs often SFTP data from a 3rd party server. If I am testing and running from home, I want to download data but not delete it from the 3rd party server. When the report is running in production mode, the data needs to be deleted after download.

In the past, I've used the computer name to decide whether the program should run test or production ( I check the name of the computer inside the VBA code). I know the name of the remote computers. The problem is that the remote computer names can change, and the computers running production off the server can change as well.

Is there another way that I can be absolutely sure that I am running remotely?