LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
|


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import data to specific columns marlea Excel Discussion (Misc queries) 1 August 12th 05 02:05 AM
Import external data "PROBLEM" Roger MacInnis New Users to Excel 4 July 13th 05 05:08 AM
Chart/Source Data update problem Rich Charts and Charting in Excel 1 July 4th 05 04:35 PM
Problem with external data baz Excel Discussion (Misc queries) 0 March 31st 05 10:47 AM
Automatic Data Import TxRaistlin Excel Discussion (Misc queries) 2 February 4th 05 10:43 PM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"