View Single Post
  #4   Report Post  
Jim Rech
 
Posts: n/a
Default

I don't know if this will help you, but I found that if I ran this macro
twice, the second time defaulted to the folder picked in the first run.

Sub GetImportTextFile()
Application.Dialogs(xlDialogImportTextFile).Show
End Sub


--
Jim
"Barry Treadway" wrote in message
...
| The problem is, my data's all stored in the "Data" folder (it's all
| engineering test data). In that folder are five folders, one for each
type
| of test being run. In each of these folders are 3-5 folders, one for each
| instrument/test station. In each of these folders are 2-3 folders, one for
| each operator. In each of these folders are a series of folders labeled
by
| the date of the test. In each of these are a few folders describing what
was
| tested that day. Sometimes there's an A and B folder in these for
repeated
| tests. The actual data folders are there. So even if the "Import Data"
key
| defaults to the "Data" folder, I still have five layers to navigate
through
| to get to each file, and there are up to 10 individual files per test. So
| where the old system, which defaulted to the last place visited, was
| effortless, I get so many errors now when technicians navigate to the
wrong
| file once or twice in the 50 times they have to navigate to the data
files
| that I'm thinking of going back to '97 and asking for my money back for
2002.
|