There are lots of methods. Do you mean that you haven't been successful in
accessing the files using \\server\share\...", or you don't have permission
on your server to get the files in this manner. Yo may be having problems
because you filename (including path) excecess ~126 characters. The solution
would be to map a network drive to a subfolder on the network drive. DIR()
won't find files on network drives but a "file scripting object" will find
the file names.

You could use FTP to download the files and then open them from you local PC.

Can you see the files using a window explorer and if you can can you open
the files with the windows explorer.

"Christer" wrote:

I want to automate a process where files (Excel or Word) are places in an
Eroom on the Intranet and access them via VBA. I don't know any path exept
the hyperlink.
I'am not allowed to access the files using the "\\server\share\..." manner.
Is it by any mean possible to do so?

Hope I have supplied enough information

/Christer