pdf writer Question And Answer
Why does my PDF writer save files to "My Documents", using a macro in Excel?
I am using Adobe PDF writer (I believe) to create PDF files of a spreadsheet in Excel. I want them to save in the Rates folder, but they always get created in My Documents. Can someone tell me why? The code I am using is as follows:
Workbooks.Open Filename:="L:\RATES\External.xls"
Sheets("Cash").Select
Application.ActivePrinter = "Acrobat PDFWriter on LPT1:"
ChDir "L:\rates\"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="Acrobat PDFWriter on LPT1:", prtofilename:="L:\rates\cash"
Kill "L:\rates\cash"
So it should be saving the pdf file as cash.pdf in the L:\Rates folder, but instead it always defaults to My Documents. Any help would be greatly appreciated!
Thanks.
Answers
Go to file ----> save as -------> and selected them to go to a specific place.. If you dont they will default to my documents.
It is obviouse, the path for the file name must contain the extension (Last three characters after the Dot) the file name should be Cash.pdf not just Cash
And then the path should be
"L:\rates\cash.pdf" not just "L:\rates\cash"
The Printer see that the folder is not found, so the folder is back to the default one "My Documents"
good luck
Read my profile, I am XLMan
