View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Javed Khan Javed Khan is offline
external usenet poster
 
Posts: 1
Default VBA macro for reading text file into Excel

Hi,
I have text file created by an application. I need to read that into excel. The structure of the text file is as follows:
(a) Several lines of text of equal length, with blank lines interspersed.
(b)A text line with headers identifying the data in that follows
(c)Several lines of data. This data in each line is tab delimited. Some data is text others are numbers
(d) The data lines are follwoed by at least one blank line

I then want to write the data columns selectively to another sheet. This selection would be based on the headers and the rows if the data in one of the columns (which is text) is not a certain alphabet.(say P).
Would appreciate help. Thanks

EggHeadCafe - Software Developer Portal of Choice
Play Embedded Sound Resources in .NET
http://www.eggheadcafe.com/tutorials...und-resou.aspx