Search for string of text only within "*.log" files in the folder

[harkirat777]

Hi

I have a VBA function which searches inside all the files in a folder for the specific text and extract the value in the excel spreadsheet.
There are 3,000 files in the folder only 1,500 of them are "*.log", which are of interest to search within.

I am using the code below to search within each file:

Please Login or Register  to view this content.

Can it be possible to filter files to search only "*.log" files, and then start searching for matching text?

Thanks
Harkirat

[ragulduy]

Please Login or Register  to view this content.

you might need to change opentextfile(filname,1) to include the folderpath.

[harkirat777]

Please Login or Register  to view this content.

you might need to change opentextfile(filname,1) to include the folderpath.

Thanks a lot Yudlugar for your reply

I am getting compile error "argument not optional" at .READ in

Please Login or Register  to view this content.

Can you help again please

Thanks
Harkirat

[ragulduy]

Have you tried:

Please Login or Register  to view this content.

?

[harkirat777]

I tried just now, giving same compile error.
I then tried:
Debug.Print filname

no output?

[ragulduy]

Ok,

I've built some dummy files and tested this one and seems to work:

Please Login or Register  to view this content.

note - you need to change E:\ to your folder path.

[harkirat777]

Thanks a lot for your effort and patience.

1) Your code works fine with hardcoded Dir filename, but it does not loop through all the LOG files, only reads first file

Please Login or Register  to view this content.

whenever I use variable in dir function, it does not work

Please Login or Register  to view this content.

2) Why am I not getting any output with: (filename retuned by DIR() is a text string)

Please Login or Register  to view this content.

3) Why am I not able to do this (invalid procedure call) however, it is a TextStream Object..?

Please Login or Register  to view this content.

because I later need a text string to SPLIT

Please Login or Register  to view this content.

****************************************
Below is the code I am using:

Please Login or Register  to view this content.

[ragulduy]

Hi,

1. When you use the variable in your code, the variable is set to

Please Login or Register  to view this content.

so your dir command is looking for files title "New Folder*.log" in the root of C, you need to use:

Please Login or Register  to view this content.

[/CODE]
2. No idea, what do you mean by output?
3. I think maybe you need:

Please Login or Register  to view this content.

[harkirat777]

Thanks a ton Yudlugar.

Please Login or Register  to view this content.

did the magic

and I was just being mysef: SILLY
I didn't do:

Please Login or Register  to view this content.

Thanks