B
bw
I sent this earlier, but without a subject, and the news group appears to require a subject,
so I'm sending it again....
--------------------------------------
I have the following two statements (among others, of course):
TheFileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")
Workbooks.OpenText Filename:=TheFileName, Origin:=xlWindows, _
StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=myArray
I would like the default directory to begin looking in to be C:\
I have tried the following with no success:
TheFileName = Application.GetOpenFilename("Text Files (*.txt), C:\.txt")
Thanks,
Bernie
so I'm sending it again....
--------------------------------------
I have the following two statements (among others, of course):
TheFileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")
Workbooks.OpenText Filename:=TheFileName, Origin:=xlWindows, _
StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=myArray
I would like the default directory to begin looking in to be C:\
I have tried the following with no success:
TheFileName = Application.GetOpenFilename("Text Files (*.txt), C:\.txt")
Thanks,
Bernie