M
Mark
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
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