changing directories...with vba
 

changing directories...with vb

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

thank you.

changing directories...with vba
 

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

HTH. Best wishes Harald

"mjschukas" skrev i melding
...
changing directories...with vba

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

thank you.

changing directories...with vba
 

thank you...! works great..

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

thanks!

changing directories...with vba
 

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

Best wishes Harald


"mjschukas" skrev i melding
...
thank you...! works great...

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

thanks!