Input Text File in Worksheet

[pavlo]

I am new to VB. I have a requirement to import large amounts of data that exist in text files. I have put together a simple macro that imports all the data. I would rather be sellective in what I import.

I have attached a sample file of the raw data. In this case I would like to omit any rows that start with 'C' and any ows that contain the data string 'QF 9762'.

I have looked through other examples here but cannot find anything that helps me.

Thanks in advance for any help.

[mikerickson]

Your file didn't attach, but I would look at AutoFiltering the newly imported data and removing the offending rows.
Selecting custom formula while recording a macro will give you the syntax.

[mudraker]

It all depends on how you are importingh the text files

This macro opens files
then uses Autofilter to remove unwanted rows of data

Please Login or Register  to view this content.

[pavlo]

Thanks, I will give it a try.

PP