automating Print multi files (xls or doc)

[123ASP]

hi, I have a folder in c:\myfile\ which contains 3 excel files and 3 word doc.
Is there a code or command file that I can run to print all the content of myfile that has an extension .xls.
I tent to manually print each file. Some times I have over 30 xls files to be printed, so I have to click each file to print then, I know there should be a better way,
thanks for your help.
Al

 

[xlhelp]

Can you not select all the files, right click and select Print? It will print to the default printer.

 

[tido213]

The suggestion I was going to make, was made after I read the question and before I posted an answer.

 

[123ASP]

I guess, I did not say what I need to accomplish, I know that I can right click the file and select print, but I do not want to do that, what I am looking for is to do something like this
for each file in the specific folder
print
next file

so if I have 50 pdf files, I can run the script from asp page and when I click a button, I will have all the pdf files printed, instead of going over every single pdf file to right click and select print.
thanks a gain for your help
Al

 

[xlhelp]

But, but, but..... you do not have to right click each file, you just need to select all of them in a folder and then right click to print all of them.

 

[123ASP]

But...Ops, how stupid I am. You are right,
But you did not answer my question though...
I still need to run the print command from within asp file to run the print command to print all the reports in that specific folder.

Is there such a command ?
Al

 

[xlhelp]

duh....sorry, don't know much about that. This might help:

http://www.aspfaq.com/show.asp?id=2014