How to output a sheet as PDF file

[Guest]

Hi all,

I have a sheet to be used as a notice to clients, I want to mail this sheet
as a attachment of email, now I can copy this sheet to a new workbook, and
email the workbook to client. the copy process takes too long, so I think I
might print out the sheet to a PDF file and email the pdf file . Is it
possible? How can I do it.

Clara

 

[Guest]

I don't know about Adobe but, this is an alternative.

Application.ActivePrinter = "Microsoft Office Document Image Writer on
Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Microsoft Office Document Image Writer on Ne01:", Collate:=True

It will save the file as "filename(your file's name).mdi" There may be
compatability issues with this. Your recipients may have to have Microsoft
Office Document Image Writer on their PCs.

 

[Guest]

Another alternative would be to have your macro send the sheet in the message
body rather than an attachment. Record a macro, choosing the "send sheet as
message body" and you can modify it to fit your needs.

 

[Guest]

Hi Jim,

Thank you for your help! The format of sheet is not allowed to be changed.

Clara
thank you so much for your help

 

[Dave Peterson]

xl2007 has an addin that will print to a .pdf file.

But if you're using xl2003 or below (or any other application), you may want to
try: www.primopdf.com

It's free and easy to use--it installs as another printer driver.