Opening the Save As Dialog in a Specific Directory

[rrenis]

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]

Const TARGET_DIR As String = "C:\personal\bob"
ChDir TARGET_DIR
ChDrive TARGET_DIR
Application.Dialogs(xlDialogSaveAs).Show

[rrenis]

:bow: :bow: :bow:

Hi xld - Thank you very much!!

Cheers,
rrenis
:beerchug: