Getting the host name of a text file

[Gmanuel]

I want from VBA, be able to read what the host name of a text file is.
For example, if the file passed to the function is on a particular
server, I want to retrieve the name of the server it resides on. Does
anyone know how I can do this?

TIA,
Gary

[Randy Birch]

What is the format of the data you would have if "the file passed to the
function is on a particular server"?

There are API calls that will indicate which files on specific servers are
currently open on local or remote machines, but this doesn't sound like what
you're after.

--

Randy Birch
MVP Visual Basic
http://vbnet.mvps.org/
Please respond only to the newsgroups so all can benefit.
"Gmanuel" <gm*****@acsnb.com> wrote in message
news:65**************************@posting.google.c om...
: I want from VBA, be able to read what the host name of a text file is.
: For example, if the file passed to the function is on a particular
: server, I want to retrieve the name of the server it resides on. Does
: anyone know how I can do this?
:
: TIA,
: Gary