Print to PDF

[mysterious-dr-x]

I'm looking to create a macro that will print a worksheet to .pdf, thus far I have the following;

Sub SavePDF()
    ActiveWindow.SelectedSheets.PrintOut From:=1, To:=2, Copies:=1
End Sub

Which isn't much I know, although it does work, so atleast there is that. Having said that, it only prints using whichever printer was last used.

How do I define that I want it to print to pdf?

In addition, I'd like the file name (from a specified cell) & save location (sub folder in same place as original excel doc) to be automatically detected, but for the user to ok them. I was going to do this using a form which I am about to go & develop, however, I've already looked into this & don't really know where to go in terms of code, so any help would be appreciated.

NB. The name of our .pdf printer is "PDF Complete"

 

[Andrew Poulsom]

It seems that PDF Complete doesn't have an API. But PDFCreator does:

http://excelguru.ca/node/21

 

[mysterious-dr-x]

It seems that PDF Complete doesn't have an API. But PDFCreator does:

http://excelguru.ca/node/21

Does that mean that I can't do what I want to using PDF Complete, or can I just change the necessary in the code you linked to?

 

[Andrew Poulsom]

The code in the link I posted applies only to PDFCreator.

 

[mysterious-dr-x]

That's not really all that helpful then.

 

[Andrew Poulsom]

Why don't you download PDFCreator? I doubt you'll get a solution for PDF Complete, particularly the automation of naming the file.

 

[mysterious-dr-x]

Why don't you download PDFCreator? I doubt you'll get a solution for PDF Complete, particularly the automation of naming the file.

I don't have the authority. I suppose I could put the suggestion forward though. Can you think of any other way around this?

 

[Andrew Poulsom]

Can you think of any other way around this?

Sorry, no.