Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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. | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
import data to specific columns | Excel Discussion (Misc queries) | |||
Import external data "PROBLEM" | New Users to Excel | |||
Chart/Source Data update problem | Charts and Charting in Excel | |||
Problem with external data | Excel Discussion (Misc queries) | |||
Automatic Data Import | Excel Discussion (Misc queries) |