| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
specify default path in dialog open box
I am using the Following to open a csv file. Is it possible to specify a
default directory path for the dialog box? For instance I would like the box to open by default pointing to this directory K:\CSR\CDM sfile1 = Application.GetOpenFilename("Text Files (*.csv), *.txt") If sfile1 < "" Then Open sfile1 For Input As 1 End If THanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specify default path in dialog open box
ChDrive "K:\CSR\CDM\"
ChDir "K:\CSR\CDM\" sfile1 = Application.GetOpenFilename("Text Files (*.csv), *.txt") HTH. Best wishes Harald "Striker" skrev i melding ... I am using the Following to open a csv file. Is it possible to specify a default directory path for the dialog box? For instance I would like the box to open by default pointing to this directory K:\CSR\CDM sfile1 = Application.GetOpenFilename("Text Files (*.csv), *.txt") If sfile1 < "" Then Open sfile1 For Input As 1 End If THanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
| Setting a default path name under Save As Dialog Box | Excel Programming | |||
| open dialog box for file path | Excel Programming | |||
| change default file path in Save As dialog box | Excel Programming | |||
| GetOpenFilename Dialog default path | Excel Programming | |||
Linear Mode
