Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
default file location | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
Save as Default folder | Excel Discussion (Misc queries) | |||
how do i set default font / text size in comments? | Setting up and Configuration of Excel | |||
Linking an entire worksheet from a restricted drive? | Excel Worksheet Functions |