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

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