Hi--
ERm
ill get shot for this one but why need to...
load Adobe Reader V5 FREEWARE and select all PDF file and print them.. some programme will solve this buy simple explore dir or find PDF and select to print... hardly worth the VB Script to d that, and you have manual control over as well..
Just a point i would manula do tjis in seconds...
BTW now Adobe V5 has button to convert WExcel to PDF if thats of intrest to anyone.
Be carefull
Must ne down sheet no shhet to right that means.
Also must be one sheet in workbook else others will be lost..
takes seconds,,, OK 30 seconds to convert...