Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to get a macro which imports any text file selected from a
directory C:\Data\Archive. The recorded macro is: With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Data\Archive\Mydata.txt", Destination:=Range("A1")) .Name = "Mydata" etc. This relates to a specific file whereas I want to import any text file in that directory I've tried lots of variations including: With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Data\Archive", Destination:=Range("A1")) .Name = Application.GetOpenFilename but they don't work. I'd really appreciate any ideas. Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
Help Importing Text File! | New Users to Excel | |||
Importing Text File | Excel Discussion (Misc queries) | |||
importing text file, removing data and outputting new text file | Excel Programming |