changing directories...with vba

M

mjschukas

changing directories...with vb

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

thank you.
 
H

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
 
M

mjschukas

thank you...! works great..

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

thanks!
 
H

Harald Staff

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

Best wishes Harald
 
Top