runtime error 52 bad file name or number

[fabdullaster]

I am using Excel 2007, I have the code below it tries to run and when it gets 513 files it gives me the error message "runtime error 52 bad file name or number"
What i have is I select txt files then open each one put those into an array. Then i have some other code that goes to each array(file) and checks for some information that i am interested in.

When i went to debug it took me to Open mFleNm For Input As #file, I put the mouse over the mFleNm and the path looks correct and the file was 513. I had selectd 945 files.

Please Login or Register  to view this content.

Any ideas what is causing this to stop and give the error mentioned above.

Your help is appreciated.

Thanks


Moderator's Note: Welcome to the forum. Codes should be enclosed with code tags. Select the code then hit the "#" sign. I'll do it for you now. Thanks.

[watersev]

hi fabdullaster, welcome to Excelforum, the problem comes from file variable being simultaneously used as FreeFile and loop counter. Make them separate variables(differently named) and it should be ok then

[watersev]

or alternatively do not use a separate variable for FreeFil:

Please Login or Register  to view this content.