Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excels slows when changing directories | Excel Discussion (Misc queries) | |||
Simplify changing directories | Excel Worksheet Functions | |||
sub directories | Excel Programming | |||
Directories | Excel Programming | |||
changing directories | Excel Programming |