1

I have this code.

pdfCreator.ActiveSheet.PrintOut copies:=1, ActivePrinter:= _
"PDF Complete on PDFC", collate:=True

How can i add a save location to this code . My default is the desktop when
i save all the the file to be converted my desktop becomes a mess . can anyone
help me how can i save it to a specific location.

thank you!!

2
Contributors
4
Replies
17
Views
5 Years
Discussion Span
Last Post by imBaCodes
1

Is the pdf printer driver for saving files or printing? What library are you using for pdf's? What pdf printer driver are you using?

Edited by tinstaafl

1

PDF Complete . thats what im using its built in on my 2003 excel .. and im using it for printing an excel sheet to pdf.

1

PDF Complete is an add on for Office. You'll probably have to check out the documentation on their website. Normally though the printer driver itself should have an option to save the file through the save-as dialog.

Edited by tinstaafl

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.