Dear Mark,

I saw your code and it's so greate! But I have another question about using excel to print on the VFP. You are using VFP report on your coding. Can I also control the default file name on EXCEL? It is because I must port the data into EXCEL and using some EXCEL printing function (such as Fit to one page etc.). And I most concern the file name prompt when I print the report via PDF writer. If anyone or you can help me to default the file name during printing, I don't care which method or driver to use. My boss always like this!!

As before, I saw a sample coding (Thread #385817, Message #386619) to default the file name for PDF writer. But I can't find a .DLL file (PDFMon.DLL) as mention, I have install PDF writer which is V3.03 version. Please help me and thanks a lot to everybody.

Thanks for any help and advice.

Best Regards,

Justy Chow