vba and recursive searches?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
G

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
 
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?
Click to expand...

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
 
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.
Click to expand...

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
 
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?
Click to expand...

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