Default Drive Question
I have read posts explaining why chdrive is needed to
make sure the right drive is the default drive. Thanks, Messrs Peterson and Ogilvy. I have the following two lines of code, but the default drive used by the print statement in this case isn't affected by the chdrive statement. Any idea why? If I do a filesaveas command from file menu and save the file to the c drive then the PDF will go to that drive. chdrive "g" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on G:\Pdf\*.pdf", Collate:=True The drive used for the creation of PDF file isn't affected by chdrive command. Any ideas? |
I don't know enough about Adobe and PDF's to be useful, but maybe this post by
Jim Rech will lead you to an alternative solution: http://groups.google.co.uk/groups?th...%40tkmsftngp03 Mel wrote: I have read posts explaining why chdrive is needed to make sure the right drive is the default drive. Thanks, Messrs Peterson and Ogilvy. I have the following two lines of code, but the default drive used by the print statement in this case isn't affected by the chdrive statement. Any idea why? If I do a filesaveas command from file menu and save the file to the c drive then the PDF will go to that drive. chdrive "g" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on G:\Pdf\*.pdf", Collate:=True The drive used for the creation of PDF file isn't affected by chdrive command. Any ideas? -- Dave Peterson |
Thanks for your time. I looked at it and tried what it
said, but my system doesn't have a PDFwritr.ini file or anything close. Maybe windows XP has this information set in a registry entry somewhere rathen and a .ini file. However, I guess its not important enough to pursue further since the solution probably won't be simple. Thanks again for your time. -----Original Message----- I don't know enough about Adobe and PDF's to be useful, but maybe this post by Jim Rech will lead you to an alternative solution: http://groups.google.co.uk/groups? threadm=uqnWuLu4AHA.1908%40tkmsftngp03 Mel wrote: I have read posts explaining why chdrive is needed to make sure the right drive is the default drive. Thanks, Messrs Peterson and Ogilvy. I have the following two lines of code, but the default drive used by the print statement in this case isn't affected by the chdrive statement. Any idea why? If I do a filesaveas command from file menu and save the file to the c drive then the PDF will go to that drive. chdrive "g" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on G:\Pdf\*.pdf", Collate:=True The drive used for the creation of PDF file isn't affected by chdrive command. Any ideas? -- Dave Peterson . |
All times are GMT +1. The time now is 12:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com