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

Thank you guyss ..

mefatih.laid commented: convert +0

Recommended Answers

All 5 Replies

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.