opening multiple files

[Dodik]

I have a need to create a batchscript/VBscript/VBA script
whichever is appropriate to open all the excel files in a
particular directory and print them all out. Is this
possible without knowing the names of the files? (there
would be random names, and random number of files in this
directory)

thanks.

 

[Bob Phillips]

Here is a previous example that opens all text files but it could be easily
amended,

http://www.google.com/groups?selm=#[email protected]&rnum=4

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)