Getopenfilename Default File Path

This dialog box allows a user to browse files in the file system and to select a file to open. This method returns the file name without actually opening it. The selected filter is not returned, but it can be determined from the file type of the returned file. Set The Default Path/directory Using The File Dialog Box - Excel View Answers I am using a 'GetOpenFilename' method in opening a workbook, I just noticed that the default directory is the 'My Documents'.

• File Path Example
• Excel Vba Set Default File Path

C:Users usernameDocumentsHowever, the directory path of the default folder where Excel 2010 automatically saves new workbook files on a computer running Windows XP is C:Documents and Settings user nameMy DocumentsThe generic Documents or My Documents folder may not be where you want new workbooks you create to be automatically saved.To change the default file location to another folder on your computer, follow these steps:.Click the File tab and then click Options.The Excel Options dialog box appears.

File Path Example

Excel Vba Set Default File Path

Hi,I cannot figure out how to get a default path using the GetOpenFilename. I just want the open box default file path to look at 'C:trainingWindows'I dont want the file name, included, so they can pick it.I have this.UpdateFile = Application.GetOpenFilename('Update File (.csv),.csv')Workbooks.Open Filename:=UpdateFile-Which works fine i just would like, to know how to put the default file path in as well.ANy help would be greatly appreciated.Daz.