View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default How to import Text file to Excel

If you've already gotten your .txt file, then record a macro when you import it
manually the first time.


Sobhan wrote:

Hi all,
Iam new to excel programming. What iam trying to do is to read
a .txt file in CSV format from a specific directory and import that to
excel after grep(Unix System() command) for certain keyword in the
.txt file.
Do anyone has done similar thing can give a clue?

Regards
Bubunia


--

Dave Peterson