How to specific file name and file path when printing to PDF

[long0281]

Hi,

Quick question. I'm using the following VBA code to print a worksheet to PDF. How do I specify the file name and file path within the VBA code?

Thanks


Sub PrintToPDF()

Application.ActivePrinter = "Adobe PDF on Ne05:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne05:", Collate:=True

End Sub

 

[Derek Brown]

I don't know how to do this with Adobe, or even know whether it can be done.
I only use either CutePDF or PDF Creator (both free) to create PDF files - the following explains:
http://www.mrexcel.com/forum/showthread.php?t=402856