Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Driectory changing
Steve,
Known problem that should be easily circumvented by issuing a ChDrive "F" command before the ChDir or you could take a look at the GetSaveAsFileName method which shows a dialog box that allows navigating circa Windows Explorer to the directory. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Steve P" wrote in message ... I have a macro that saves a file using the getsave function I want it to default to a specific directory. The save as box always comes up but the directory is not always correct. Any thoughts? I want it to come up as f:\models\2004 strategies ' getsaveas Macro ' Change Default Directory ChDir "F:\MODELS\2004 Strategies" ' File Filters Filt = "Excel Files (*.xls), *.xls," & _ "All Files (*.*), *.*" ' Display *.xls as default FilterIndex = 1 ' Dialog box Caption Title = "Select a File Name and Directory" ' Set Initial File Name IName = "e_strategy.xls" ' Get Save as Box filesavename = Application.GetSaveAsFilename _ (InitialFilename:=IName, _ fileFilter:=Filt, _ FilterIndex:=FilterIndex, _ Title:=Title) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the range for averages with out changing the formula. | Excel Worksheet Functions | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) |