Delimited Text File and VBA

[DaveNUFC]

Hi all,

I have the below bit of code which enables me to interrogate a text file in excel and only bring back the records I want based on a certain reference number. This works great where my text file is small...

Please Login or Register  to view this content.

The difficulty is when my text file is big (e.g. a couple of million records) the above basically takes too long to process. With a bit of help I have the below code which uses ADO DB connection which I am told will be the most efficient way for interrogating a much larger database... the issue I have is I am getting an error saying 'No value given for one or more required parameters' on the .Open str part.

The column in the text file has a header of 'aa' and that is the only column I am using to search for a reference & if its there I want to bring it back into the excel document. Is there something obvious I am missing?

Please Login or Register  to view this content.

[cytop]

Assuming B2 contains a string... Some idea of the data would have been useful.

Please Login or Register  to view this content.

Short reply, just in case.

[AlphaFrog]

I think the path must use a trailing \ in the folder name.

Please Login or Register  to view this content.

[DaveNUFC]

Thanks both, still no luck with it and the .open str still highlighted in yellow.
I attach a copy of the text file I am using, for example if aa = '123' then I would want those 2 records with the '123' to be brought back into the excel file.

You'll see how this works in the import sheet. I basically want to replicate this for the module 3 macro which I am told will work better on much larger files.

Could you review both these attachments and help me flag where I am going wrong?

Cheers

[DaveNUFC]

Hi both, I wonder if this could be down to the wrong active object not being enabled?