vba and recursive searches?

[Geoff Cox]

Hello,

I have multiple presentations in sub folders, eg

c:\files\folder1\p1.ppt (p2.ppt etc etc)
c:\files\folder2\etc
c:\files\folder3\etc

etc etc

When using a macro to work on each ppt file it would be nice to set up
the file path so that all sub folder files could be accessed from the
same macro setting. Is this possible?

Cheers

Geoff

 

[Steve Rindsberg]

Hello,

I have multiple presentations in sub folders, eg

c:\files\folder1\p1.ppt (p2.ppt etc etc)
c:\files\folder2\etc
c:\files\folder3\etc

etc etc

When using a macro to work on each ppt file it would be nice to set up
the file path so that all sub folder files could be accessed from the
same macro setting. Is this possible?

Some sort of c:\files\folder*\*.ppt notation?

Wouldn't it be sweet if we could!

But (you smelled this coming, yes) we can't.

Google something like:
vb recursive subdirectory

for some possible approaches

 

[Geoff Cox]

Some sort of c:\files\folder*\*.ppt notation?

Wouldn't it be sweet if we could!

But (you smelled this coming, yes) we can't.

Steve,

I guessed so but just a thought .. perhaps I could pass the series of
different paths,on eat a time, to a sub routine which gets all the
files and does the work on them?

Geoff

 

[Steve Rindsberg]

I guessed so but just a thought .. perhaps I could pass the series of
different paths,on eat a time, to a sub routine which gets all the
files and does the work on them?

If you know that all the files will be in a limited and known set of
subdirectories, yes, absolutely.