Find File out of stack space

[ljbaum]

Greetings.
The following is the code needed to be debugged.

Please Login or Register  to view this content.

This code will find the file, the problem is that it calls itself to many time. The only way I can get it to run is change FindFile(subfol.Path) to only the FindFile name. However, this builds and builds until the out of stack error is thrown.
So I need a way, as it searches for the file, to look into the new folder for the files, and forget the previous calls on the FindFile sub. When I run it as written I get a different code that says arguments do not match.
Any help will be greatly appreciated.

Thanks

[6StringJazzer]

Please show all the code for this Sub, all the way down to End Sub. Thanks.

Also, your Sub has no arguments but you trying to call it with an argument near the bottom. This does not compile. You are getting this to run somehow but I'm not sure how you have this working.

[ljbaum]

Here is the entire code.

Please Login or Register  to view this content.

[6StringJazzer]

Please Login or Register  to view this content.

This doesn't even compile. You are providing an argument here but the definition of FindFile has no arguments. How are you getting this to run at all?

[ljbaum]

The only way I can get it to run is change FindFile(subfol.Path) to only the FindFile name. However, this builds and builds until the out of stack error is thrown.

[6StringJazzer]

If we add the missing argument, you need to change the start folder from being assigned a constant to being the argument. Otherwise you are creating an infinite stack. Here is what I think this needs to look like. Often when you use recursion you have to have a Sub that starts the ball rolling:

Please Login or Register  to view this content.

Edit: Don't use parentheses around arguments for Sub calls unless you are using the Call keyword. I removed them.

[ljbaum]

Well, it appears to be working, problem is now, there is no error, but the file keeps crashing. So I am guessing it is the file set up on our network that is the issue. However,
When I looked at the call stack, I only saw at the most 5 instances of the call.

When I step through the code, it works, I can hold down the F8 key and it runs.

So, not sure if there is a better way to write the code, or if it truly is just the way our files are set up.


Thanks for your Help!