import text file

L

Lynn

hi,
i have a macro as follows

ChDrive "c"
ChDir "c:\Mydata"
fileToOpen = Application.GetOpenFilename(filefilter:="Text Files
(*.txt),*.txt")

how can i use the above to import a text file ?
 
T

Tom Ogilvy

To open a text file:

ChDrive "c"
ChDir "c:\Mydata"
fileToOpen = Application.GetOpenFilename(filefilter:="Text Files
(*.txt),*.txt")
Workbooks.Open FiletoOpen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Opening Workbook 3
Usin OpenDiagBox to set ActiveWorkbook Name 3
Open file from path in cell and open from current file path 0
Use external file variable in formula 2
Want to read text files of random extensions into recordset 3
Help with - Get File dialoge code 2
Import Worksheets and "Overright" 9
Run-time error ‘13’ mismatch type 1

Top