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

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

Thank you Joel,
the fact is that I don't have the permisson to access the files exept using
the hyperlink. Files may (in some cases) also be accessed at the same time by
more than one user.
Could it be possible instead to put an MS Access database in the Eroom
(preferable with a frontend and backend file) and keep track of the
information? In that case all the Excel or Word files are not nessecery.


"Joel" wrote:

> 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

the prefer method when files are sharred is to use Access. Then setup a
webquery or database query using hte worksheet menu

Data - Import External Data - Import data - New Query (web or databasse).

A macro can also be used to generate the query on the worksheet. Or with a
macro you can connect to the database (either ADO or DBO methods using SQL)
and read the data. If the users are going to submit data then the ADO or DBO
methods are used.

"Christer" wrote:

> Thank you Joel,
> the fact is that I don't have the permisson to access the files exept using
> the hyperlink. Files may (in some cases) also be accessed at the same time by
> more than one user.
> Could it be possible instead to put an MS Access database in the Eroom
> (preferable with a frontend and backend file) and keep track of the
> information? In that case all the Excel or Word files are not nessecery.
>
>
> "Joel" wrote:
>
> > 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