Merging Excel Files

Hi,
I have succeeded to merge several excel files in a test environment. This is
on my own PC and network drive using Ron de Bruin's macro (Thank you Ron!).
However this must be used on another network drive where several other users
have their own subdirectories to work with. I have changed the path as
suggested but it does not work. Only when I give the name of the subdirectory
it picks the data from that subdirectory. I have set subfolders to True.
My statement works: RootPath = "\\islasrv02\Social\zone5"
My statement does not work: RootPath = "\\islasrv02\Social\"
In addition to zone 5 their are 6 other zones (=directories).
Any help is appreciated. Regards, Lupe

Hi Lupe

Try to look at it this weekend

This is the page Lupe try to use
http://www.rondebruin.nl/fso.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Lupe" <[email protected]> wrote in message news:[email protected]...
> Hi,
> I have succeeded to merge several excel files in a test environment. This is
> on my own PC and network drive using Ron de Bruin's macro (Thank you Ron!).
> However this must be used on another network drive where several other users
> have their own subdirectories to work with. I have changed the path as
> suggested but it does not work. Only when I give the name of the subdirectory
> it picks the data from that subdirectory. I have set subfolders to True.
> My statement works: RootPath = "\\islasrv02\Social\zone5"
> My statement does not work: RootPath = "\\islasrv02\Social\"
> In addition to zone 5 their are 6 other zones (=directories).
> Any help is appreciated. Regards, Lupe
>

Hi Lupe

Try to look at it this weekend

This is the page Lupe try to use
http://www.rondebruin.nl/fso.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Lupe" <[email protected]> wrote in message news:[email protected]...
> Hi,
> I have succeeded to merge several excel files in a test environment. This is
> on my own PC and network drive using Ron de Bruin's macro (Thank you Ron!).
> However this must be used on another network drive where several other users
> have their own subdirectories to work with. I have changed the path as
> suggested but it does not work. Only when I give the name of the subdirectory
> it picks the data from that subdirectory. I have set subfolders to True.
> My statement works: RootPath = "\\islasrv02\Social\zone5"
> My statement does not work: RootPath = "\\islasrv02\Social\"
> In addition to zone 5 their are 6 other zones (=directories).
> Any help is appreciated. Regards, Lupe
>

Hi Lupe

Sorry I can't reproduce your problem at home on my network
Maybe your IT department can help you

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> Hi Lupe
>
> Try to look at it this weekend
>
> This is the page Lupe try to use
> http://www.rondebruin.nl/fso.htm
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Lupe" <[email protected]> wrote in message news:[email protected]...
>> Hi,
>> I have succeeded to merge several excel files in a test environment. This is
>> on my own PC and network drive using Ron de Bruin's macro (Thank you Ron!).
>> However this must be used on another network drive where several other users
>> have their own subdirectories to work with. I have changed the path as
>> suggested but it does not work. Only when I give the name of the subdirectory
>> it picks the data from that subdirectory. I have set subfolders to True.
>> My statement works: RootPath = "\\islasrv02\Social\zone5"
>> My statement does not work: RootPath = "\\islasrv02\Social\"
>> In addition to zone 5 their are 6 other zones (=directories).
>> Any help is appreciated. Regards, Lupe
>>
>
>

Hi Ron,
What you are telling me is that it should work. I'll check with our IT
department and I'll keep you posted. Thanks again, because your macro helped
me a long way.
Regards, Lupe

"Ron de Bruin" wrote:

> Hi Lupe
>
> Sorry I can't reproduce your problem at home on my network
> Maybe your IT department can help you
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> > Hi Lupe
> >
> > Try to look at it this weekend
> >
> > This is the page Lupe try to use
> > http://www.rondebruin.nl/fso.htm
> >
> >
> >
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> >
> > "Lupe" <[email protected]> wrote in message news:[email protected]...
> >> Hi,
> >> I have succeeded to merge several excel files in a test environment. This is
> >> on my own PC and network drive using Ron de Bruin's macro (Thank you Ron!).
> >> However this must be used on another network drive where several other users
> >> have their own subdirectories to work with. I have changed the path as
> >> suggested but it does not work. Only when I give the name of the subdirectory
> >> it picks the data from that subdirectory. I have set subfolders to True.
> >> My statement works: RootPath = "\\islasrv02\Social\zone5"
> >> My statement does not work: RootPath = "\\islasrv02\Social\"
> >> In addition to zone 5 their are 6 other zones (=directories).
> >> Any help is appreciated. Regards, Lupe
> >>
> >
> >
>
>
>