PDA

View Full Version : Opening the Save As Dialog in a Specific Directory



rrenis
08-22-2007, 01:24 AM
Hi - does any one know if it's possible to specify the directory when opening the Save As dialog using the following code?...

Application.Dialogs(xlDialogSaveAs).Show

Thanks for looking.

Cheers,
rrenis

Bob Phillips
08-22-2007, 01:29 AM
Const TARGET_DIR As String = "C:\personal\bob"

ChDir TARGET_DIR
ChDrive TARGET_DIR
Application.Dialogs(xlDialogSaveAs).Show

rrenis
08-22-2007, 01:37 AM
:bow: :bow: :bow:

Hi xld - Thank you very much!!

Cheers,
rrenis
:beerchug: