Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change directory to list default | Excel Discussion (Misc queries) | |||
set default directory for saving files | Excel Discussion (Misc queries) | |||
MSOffice default directory | Setting up and Configuration of Excel | |||
Open to default directory in Excel | Excel Discussion (Misc queries) | |||
where is the default directory of excel macros ? | Excel Discussion (Misc queries) |