>Alex that is along the lines of what i intend 2 do. I just thought there may be another way to do it that I wasnt aware of:)..

I was just looking at the Amyuni CDINTF.DLL manual and it mentions a batch process, with samples in VBA sending

obj.BatchConvert(C:\*.doc")

directly to the PDF printer driver. The manual say s it launches the associated application.
It should work with Excel then; (I don't have time here at work to try it right now).