Thank you to Tracy and Anatoliy. I was able to get all sets of code to run.
However, Anatoliy, the results from your code contains a value with nulls at the end of the string. Not as usable.

Sergey's code is the easiest to use, but I had to modify it slightly. I am looking for the server that an executable is running from so I need to pass the drive letter to the code. A minor change and works very well.

Many thanks to you all for your quick reply.