Path, file name, and extension of the selected file. If the buffer is too. Long pointer to a buffer that contains the default extension. GetOpenFileName and. Sep 29, 2003 Experts Exchange >Questions >GetOpenFileName makes Excel to crash when selected too long. Files (*.xls),*.xls' ' Show *.* default. GetOpenFilename 'Workbooks. Yes initially i started with that but if the file path is the same i can define it.or if you see my comments under that code its too long. So i can use (ThisWorkbook.Path) should directly go to. If you want to set the initial path then look here: mrexcel.com/forum/excel-questions/.

I'm trying to adopt the Application.GetOpenFilename method, so I can let go of the dependency for comdlg32.ocx, which is not included in Vista. However, I haven't found a way to have GetOpenFilename start with a default filename. Starting in a given directory works (if I call it before calling GetOpenFilename), but I wonder if it's possible to have the dialog box open with a default filename in that directory? That is, when the dialog opens (in the given directory), the default file should be pre-selected. Is that possible? You need to use chdrive and chdir before calling the getopenfilename.

Chdrive('h:') chdir('temp') 'Gustaf' wrote: >I'm trying to adopt the Application.GetOpenFilename method, so I can let go of the dependency for comdlg32.ocx, which is not included in Vista. However, I haven't found a way to have GetOpenFilename start with a default filename. Starting in a given directory works (if I call it before calling GetOpenFilename), but I wonder if it's possible to have the dialog box open with a default filename in that directory? That is, when the dialog opens (in the given directory), the default file should be pre-selected. Is that possible? Thank you, but maybe you didn't read the question in detail.

I'm not asking for default directory, but default filename. Also, when you open default directory, I have found it better to call Private Declare Function SetCurrentDirectory Lib 'kernel32' Alias 'SetCurrentDirectoryA' (ByVal lpPathName As String) As Long rather than ChDir(). It works with UNC (network) paths too. If the answer to my question is 'you can't do that', that would be okay too.

Gustaf Joel wrote: >You need to use chdrive and chdir before calling the getopenfilename. >>>chdrive('h:') chdir('temp') >>'Gustaf' wrote: >>>I'm trying to adopt the Application.GetOpenFilename method, so I >>can let go of the dependency for comdlg32.ocx, which is not >>included in Vista. However, I haven't found a way to have >>GetOpenFilename start with a default filename. Starting in a given >>directory works (if I call it before calling GetOpenFilename), but >>I wonder if it's possible to have the dialog box open with a >>default filename in that directory?

That is, when the dialog opens >>(in the given directory), the default file should be pre-selected. >>Is that possible? >>>>Gustaf >.

I tried various alternatives to 'Text Files (*.txt), *.txt') eg 'Excel Files (*.xls),abc.xls' but they don't 'pre select' the required file. So i guess it can't be done. 'Gustaf' wrote in message news:#. >Thank you, but maybe you didn't read the question in detail. I'm not >asking for default directory, but default filename. Download Bbm2 Apk Versi Terbaru.