View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_61_] Mark[_61_] is offline
external usenet poster
 
Posts: 1
Default Deleting rows before importing

I import text files daily into EXCEL using a wizard. However what I
would like to do is import them without a wizard. The problem I have is
that using the wizard I can set text file to start importing at the
10th row or 50th row or even the 3rd row. Every day the file will be
different dependin on the amount of data on the text file. In between
the data sets on this text file are 4 or 5 rows I want deleted.
Basically there are 7 data sets, with useless data rows at the top and
in between each data set. Can this import be done programatically? If
can some one show me how.

Mark