With Application.FileSearch error

Hi all!

I have been using the code below for a while now. It imports all txt files (semicolon delimited) from a folder, deletes the header row of all files, and places them underneath eachother in the first empty row in my sheet.

We have now changed from excel 2003 to excel 2007 at the office. The code below then errors on the With Application.FileSearch. After websearches I realize that the code does not exsist in 2007 version, and that the does also not exist a "replacement" code.

I have been trying for a a couple of days now to modify the code, without any success.

I sincerely hope someone can assist me in modifying the code (I am not very good at programming).

Please Login or Register  to view this content.

Best regards
Gnoke

Not tested but try this:

Please Login or Register  to view this content.

Dom

Please Login or Register  to view this content.

(Posting replays/questions to both that helped me)


Fantastic Domski! It is almost perfect

One small issue however. I get an error message saying that the folder C:\files\newImport cannot be found. That is strange, because all files except the oldest is imported.
Any ideas?

Gnoke

(Posting replays/questions to both that helped me)

Thanks a lot snb
The code imports all files, but they are not imported semicolon-delimited.
Is there a simple way to change this, and maybe delete the header row of the txt files as well?

You guys rock!

Gnoke

Hi,

There was a 2008 thread in this forum which deals with this.
http://www.excelforum.com/excel-prog...in-2007-a.html

Rgds

Thanks for the link.

I have been using what I`ve learing here and this link combined: https://sites.google.com/a/madrocket...svs-to-1-sheet

The code however, misses the same as snb`s above. The imported txt files are not imported semicolon delimited and that the header row is not deleted from each txt file.

Please Login or Register  to view this content.

Gnoke

You can use teh method texttocolumns to split column 1 into different columns.
In your original code the headers were not filtered out either.
if headers have a specific property you can easily filter with

Please Login or Register  to view this content.

Put a line in the wrong place I think:

Please Login or Register  to view this content.

Dom