Error 6 Overflow on Folder Loop

First of all - I would like to apologize RIGHT off the bat.

I am new to VBA and have kind of been winging it - I've been fairly successful, but I know I'm very inefficient and have a billion things to learn.

I'm trying to loop through a folder and run this code on all files in a folder. The code worked fine on individual files, but it's giving me overflow or out of range errors with the loop. I'm sure it has to do with the way that I have my integer loops set up.

Please be gentle. I know it's not great, I'm just trying to learn.

Please Login or Register  to view this content.

Forgive my ignorance - I can do that and still run as a loop with arithmetic?

Yes. Long is basically 4 bytes version of integer and limit is around 2mil.

See if this change works

Please Login or Register  to view this content.

I made this change but I then get a compile error for expected array.

Compile Error?

You have some variables not declared.

Add one line on the top of module

Please Login or Register  to view this content.

And do a step debug.

I ran that and nothing is coming up as not defined, but at

Please Login or Register  to view this content.

I am getting a compile error for expected array

Then you didn't add that line.

If I run your code with that line on the top of the module, it doesn't compile due to undeclared variables

Debug.Print Workbook
CampAccom = "CC30000"
travel = "CC_Travel / Entertainment"
meals = "CC_Meals"

You're correct - I'm not awake enough and apparently added it above the sub. Give me a moment to fix those variables and try again

I defined all those variables and correctly placed the option explicit statement and I'm still getting the same error

Is it potentially because a and b are defined as integers, whereas result1 is defined as long?

If the error is Overflow, it would be a variable type.

Why are you define Integer?, there is no advantage for it, AFAIK, so I always use Long anyway.

Will check that and try again, thank you

It's still pulling that error and I have zero idea why

Edit: It's not giving an overflow error. It's saying

Compile error: Expected array

Since you are the only one who can actually test the code,
While you are in VBE, Go to [View] - [Local Window]
Then run the code.
When the code get into debug mode, see local window and find variable "result1" and see what's happening.

I apologize again for my naivety. I did bring up the locals window, but nothing is popping up in the window when I run the code.

I did, however, comment out the line with result1 and run it again, and I received the same error for result2.

That's really strange.

Just try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and add 1 line right after last dim statement

Please Login or Register  to view this content.

And see what happens.

If it still give you an error, I suggest you to create a new workbook...

When you get the compile error, does the VB editor highlight a particular line of code? If so, which line?

1) Did you change Integer to Long?

2) change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks for the notification solution.

I changed the integers for the given letters (a/b/n/i) to long
When I change the "result1" and "result2" to long, I get the compile error at the location stated earlier.

No.... You should not change the type of arrays.
Leave them as they are and change only a,b,n and i

Yes, I ran it that way and it eventually went out of range. Should I expand the range of result1 and result2?

OK, expand the array like 1 to 200000 or whatever you think it is more than enough.

I put it up to 2000000 which I'm sure is awful practice, but the whole thing worked. Thank you very much.