Browse for folder error

Thanks shg. I tried the code you posted but for some reason regardless of the folder I chose, it gave me only the txt files on C:\. I don't know why its ignoring my decision and defaulting to C:\.

I have been working on it all day and make a breakthrough (at least a small one) and got the original code to work. Here is the modified code:

Please Login or Register  to view this content.

Even though, it works only to give me the file names in a msg box. When I try to combine it with other code, I get an error saying that the file does not exist. Below is an example which incorporates the code above with the code that you generously created for me in a previous thread.

Please Login or Register  to view this content.

I don't know why it doesn't work even though I got to work earlier today, but like an idiot I forgot to save the file and I can't get it to work again. I have been pulling my hair out at the roots because I am so frustrated with this. I hope you can help me resolve this issue.

Thanks again.

abousetta

Hi shg,

I dont' know if there is something wrong with my system or what, but last night I finally got it work. So to test it, I saved the xlsm file and reopened it to see if worked and it wouldn't work again. It started giving me the same errors again. As a last ditch attempt I am uploading the excel file with the two modules containing the modified code that at one time worked and the code you posted yesterday. Also I am uploading three identical dummy text files that I used for test runs.

I hope you can help me out because this looping through files issues is critical to my project.

Thanks.

abousetta

Hi again,

OK, now I know that I am not crazy because I got it to work again (this time on another computer). Once I saved the file and reopened it, it won't work again. I have stripped the code down the to the basic part to show where it hangs.

Please Login or Register  to view this content.

It stops at the following line of code:

Please Login or Register  to view this content.

When I change the code to just send the file name to a messag box, it works fine, but it seems to have a problem opening the file. I hope you could tell me why this happening.

Thanks.

abousetta

Another addition to this saga.

I have checked again on a completely different computer than the ones I have used before and the problem doesn't seem to be with the BrowseForFolder Function. I am assuming this because I have replaced the function with the actual path and it worked... the first time. And then every time after that it gave the Run-time error '53': File not found. Even when I create a new workbook and add the code to a new module, it still gives me the same error. Its as if the files are now locked for use by only the first instance of the macro running. Could there be some hidden link that is causing this bug?

abousetta

Thanks JB... It has been a very big help. I tried it out right now and maybe the real culprit was the function after all. I don't know anymore...

I want to be optimistic and say that it is working fine but I don't want to jinx myself. I will say that my first trial run worked well and I will keep testing it in different environments and make sure the issue truely is solved.

Thanks again everyone. And of course a special thanks to shg and JB who have put up with my numerous posts.

Best wishes,

abousetta