Member Avatar for imBaCodes

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

Thank you guyss ..

  • 3 Contributors
  • 5 Replies
  • 250 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by imBaCodes
mefatih.laid commented: convert +0
Member Avatar for Reverend Jim

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

Member Avatar for imBaCodes

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

Member Avatar for Reverend Jim

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

Member Avatar for imBaCodes

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.