Can i convert an excel file to PDF file ..
can anyone give me an example macro ..

Thank you guyss ..

commented: convert +0

There are several free programs that install print-to-pdf pseudo printers. I've been very happy with PDFCreator

I still dont have any idea ..
I tried many macros ..
but i always fail..

You don't need macros. Install PDFCreator then just print to the pseudo-printer. It will create the PDF for you.

pdfCreator.ActiveSheet.PrintOut copies:=1, ActivePrinter:= _
"PDF Complete on PDFC", collate:=True

Thanks i already converted it to pdf. But it always ask a filename. how cana i automate it
for saving automatically .. can you help me?