changing directories...with vba

[Guest]

changing directories...with vb

i would like to change the default directory (e.g., for use with the file save as)..

thank you.

 

[Harald Staff]

Sub test()
Dim Mydir As String
Mydir = "C:\Temp"
ChDrive Mydir
ChDir Mydir
Application.Dialogs(xlDialogSaveWorkbook).Show
End Sub

HTH. Best wishes Harald

 

[Guest]

thank you...! works great..

and now, how can i control the: "Save In", "File Name", and "Save As Type" comboboxes..

thanks!

 

[Harald Staff]

Dialogs are for human interaction. What is it you want done ?

Best wishes Harald