Thank you very much for spending ur time with my query.

Is it possible to print the same data in word document format.

that means when I run the macro, both pdf and doc should be printed simultaneously from the excel output