Printing all files in subfolders

[adammoo1984 via AccessMonster.com]

Guys and Gals,

Hope you can help me because I have spent all day trying to figure this out.
Basically the subject says it all. I am trying to print all PDF files in a
selection of subfolders. The directory they're stored in is C:\Documents and
Settings\Adam\Desktop\Folder\Subfolder. I want to choose the Folder and then
it prints all from the subfolders (these are named A, B, C to AX, AY, AZ).

Any further details needed then please ask but also please help.

Thanks,
Adam.

 

[Dale Fye]

Take a look at the Dir( ) function. You might also want to google on
something like:

VBA +dir +function +interate

or checkout this url:
http://office.microsoft.com/en-us/access/HA012288241033.aspx

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Allen Browne]

See:
List files recursively
at:
http://allenbrowne.com/ser-59.html

The code shows how to list the files, and can log them to table (from where
you could print them), or show them in a list box.

 

[adammoo1984 via AccessMonster.com]

Thanks Guys,

I managed to get it to work by fudging 2 sets of code - Allen Browne's code
plus a bit I found in the forums here which is:

strShell = Chr$(34) & _
"C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe" & _
Chr$(34) & " /p /h " & Chr$(34) & varItem & Chr$(34)
Shell strShell, vbHide

As per usual you've help loads.

Ta,

Adam.