Hi Tom and thanks for your answer. Today I posted the question below (maybe
you
saw it):

"Hi there,

The facts:
- I have a folder with 50-60 files, each file having more than 10 sheets;
- the files are pretty big (some of them 40mb+) and are linked to many other
files from various locations from the network;

What I would like to do is:
- to verify whether all files are comprising a sheet named for example "Abc";

The code currently used by me is doing this check, but it is necessary to
open each file from the respective folder. The issue is that due to big
number of files, size and links, the execution of this code takes few hours.
Thus, my code is useless.

The question: is it possible to make this test without opening the files?"

I kindly ask you for help me on this, because I cannot figure out how to do
it. Someone suggested me to use ADO, but...

Many thanks in advance,

See the previous thread. Answered there.

--
Regards,
Tom Ogilvy


"Bogdan" wrote:

Hi Tom and thanks for your answer. Today I posted the question below (maybe
you
saw it):

"Hi there,

The facts:
- I have a folder with 50-60 files, each file having more than 10 sheets;
- the files are pretty big (some of them 40mb+) and are linked to many other
files from various locations from the network;

What I would like to do is:
- to verify whether all files are comprising a sheet named for example "Abc";

The code currently used by me is doing this check, but it is necessary to
open each file from the respective folder. The issue is that due to big
number of files, size and links, the execution of this code takes few hours.
Thus, my code is useless.

The question: is it possible to make this test without opening the files?"

I kindly ask you for help me on this, because I cannot figure out how to do
it. Someone suggested me to use ADO, but...

Many thanks in advance,

sorry ignore the message

"Tom Ogilvy" wrote:

See the previous thread. Answered there.

--
Regards,
Tom Ogilvy


"Bogdan" wrote:

Hi Tom and thanks for your answer. Today I posted the question below (maybe
you
saw it):

"Hi there,

The facts:
- I have a folder with 50-60 files, each file having more than 10 sheets;
- the files are pretty big (some of them 40mb+) and are linked to many other
files from various locations from the network;

What I would like to do is:
- to verify whether all files are comprising a sheet named for example "Abc";

The code currently used by me is doing this check, but it is necessary to
open each file from the respective folder. The issue is that due to big
number of files, size and links, the execution of this code takes few hours.
Thus, my code is useless.

The question: is it possible to make this test without opening the files?"

I kindly ask you for help me on this, because I cannot figure out how to do
it. Someone suggested me to use ADO, but...

Many thanks in advance,

Which previous thread?

"Tom Ogilvy" wrote:

See the previous thread. Answered there.

--
Regards,
Tom Ogilvy


"Bogdan" wrote:

Hi Tom and thanks for your answer. Today I posted the question below (maybe
you
saw it):

"Hi there,

The facts:
- I have a folder with 50-60 files, each file having more than 10 sheets;
- the files are pretty big (some of them 40mb+) and are linked to many other
files from various locations from the network;

What I would like to do is:
- to verify whether all files are comprising a sheet named for example "Abc";

The code currently used by me is doing this check, but it is necessary to
open each file from the respective folder. The issue is that due to big
number of files, size and links, the execution of this code takes few hours.
Thus, my code is useless.

The question: is it possible to make this test without opening the files?"

I kindly ask you for help me on this, because I cannot figure out how to do
it. Someone suggested me to use ADO, but...

Many thanks in advance,

Thank you very much. I tried it and it is working. Now, I'll try to
understand it and
I'll try to adapt it to my needs.

Thanks again,

Bogdan

"Tom Ogilvy" wrote:

See the previous thread. Answered there.

--
Regards,
Tom Ogilvy


"Bogdan" wrote:

Hi Tom and thanks for your answer. Today I posted the question below (maybe
you
saw it):

"Hi there,

The facts:
- I have a folder with 50-60 files, each file having more than 10 sheets;
- the files are pretty big (some of them 40mb+) and are linked to many other
files from various locations from the network;

What I would like to do is:
- to verify whether all files are comprising a sheet named for example "Abc";

The code currently used by me is doing this check, but it is necessary to
open each file from the respective folder. The issue is that due to big
number of files, size and links, the execution of this code takes few hours.
Thus, my code is useless.

The question: is it possible to make this test without opening the files?"

I kindly ask you for help me on this, because I cannot figure out how to do
it. Someone suggested me to use ADO, but...

Many thanks in advance,