Importing Text file into Excel 2003

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Can I get some sample VBA code which would import a text file into Excel
2003.

Thanks,
Ray
 
Workbooks.Open "C:\MyFolder\MyFile.Txt"
or if you have Excel 2000 or later, turn on the macro recorder and to

Data=>Get External Data (or Import External Data) and navigate to the
Import Text file option and import your data manually.

If you need parse the text file, then for the first method turn on the macro
recorder as well and go through the text import wizard - it will record
arguments to the OpenText method.
 
Great idea. Thanks Tom!

Tom Ogilvy said:
Workbooks.Open "C:\MyFolder\MyFile.Txt"
or if you have Excel 2000 or later, turn on the macro recorder and to

Data=>Get External Data (or Import External Data) and navigate to the
Import Text file option and import your data manually.

If you need parse the text file, then for the first method turn on the
macro
recorder as well and go through the text import wizard - it will record
arguments to the OpenText method.
Click to expand...
 
You must log in or register to reply here.

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

Utility to flatten/import X12 834 file into Excel 3
Date formatting in VBA 1
Import Text file Data into Excel Sheet 3
VBA Code to monitor standard toolbar buttons. 1
Excel 2011 Mac - Import Worksheets into a Single File 0
import from text file with VBA code 5
Importing any excel files with any sheet name into different tables in MSAccess using code 0
Macro that will insert a simple text string in top cell of text file 1

Back
Top