LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mel
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
default file location maryj Excel Discussion (Misc queries) 2 March 3rd 05 06:09 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
Save as Default folder Gerry Cornell Excel Discussion (Misc queries) 2 December 13th 04 06:41 PM
how do i set default font / text size in comments? philk Setting up and Configuration of Excel 1 November 28th 04 03:20 PM
Linking an entire worksheet from a restricted drive? mkichar Excel Worksheet Functions 1 November 4th 04 06:29 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"