View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Boris Boris is offline
external usenet poster
 
Posts: 67
Default A Macro that gets data from an ASCII file

All,

I would like to write a Macro that does the following:

1. Opens an ASCII file (e.g. a *.txt or *.raw file)
2. Copies the data from the ASCII file into the Excel file.
Every line from the ASCII line should be inserted into a new row
3. closes the file

Could someone tell me how to do this?

Best,