Dear Mark,

Thank you for your help and reply. I didn't missing file on your coding. Your code is perfect but it just only for VFP report. I need to use EXCEL to generate the PDF. That means I need to install PDF writer printer driver and want to default the file name to bypass the dialog window. I miised the file on my computer as before mention. Thanks a lot.

If you have any suggestion or experience about PDF printing, please send or share with me.

Best Regards,

Justy Chow