Move to next file if condition fails

[pratnimk]

Hello

I'm running a macro to open files in a folder and process the data in excel
Steps:
1. Open file
2. Look for a condition (Job ID Exists)
a. PASS -> further processing, excel entries, close file, loop onto next file
b. FAIL -> I would like the macro to close that particular file and move onto the next file in the folder

I've attached the current macro that I have now
where I am able to open the file and look for pass condition and process the file
however, I am struggling with the fail condition

Please Login or Register  to view this content.

Please help

Thanks
P

[JBeaucaire]

A little reorganizing overall, then a simple EXIT DO for your loop:

Please Login or Register  to view this content.

[pratnimk]

Hello Jerry

Thanks for your reply
The code that you have sent works well

However, it doesn't work when I add the rest of my code

Let me add that here

Please Login or Register  to view this content.

A little reorganizing overall, then a simple EXIT DO for your loop:

Please Login or Register  to view this content.

Please help

Thanks in advance
P

[JBeaucaire]

OK, so when that first IF statement kicks in the first loop and the test is FALSE, what exactly is to supposed happen? There are two loops in there now, so exiting the first as I demonstrated would then close the first and proceed to the second. What is wrong? What should happen? Be specific, note code lines if necessary.

[pratnimk]

Hello Jerry

Apologies for being ambiguous in my previous post
What I'm looking for is

1. Open the file
2. Check for condition -> text = JobID (1st loop)
3. If JobID exists (Condition - Pass) move to next loop where it retrieves the report path and then the loop after (not added as it is written in the same way) to retrieve other text from the file
I've written a separate loop for each of the other parts of text due to lack of knowledge on how to get it done together in one single loop
(Yes I know it is performance in-efficient )
4. If JobID does not exist - it should simply exit this loop and not move to the next loop either and move to next file itself

I'm not sure if this can be achieved in a single loop...can it?

Please advise

Thanks
P

[JBeaucaire]

Not going to rewrite the whole macro, but you can use a GOTO command in the ELSE to jump to the just above the second CLOSE #1 and that will effectively skip all that code...

Please Login or Register  to view this content.

[pratnimk]

Hello Jerry

This resolved my issue

Thanks a lot for bearing with me

Cheers
Thanks
P

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.